Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Import Microsoft Excel File
Contents
[
Hide
]
Like Aspose.Cells.GridDesktop, Aspose.Cells.GridWeb control can open and load Microsoft Excel files — complete with data, formatting, charts, images, etc. — but in web applications. This topic explains how.
Import Excel Files
Import from File
To open an Excel file using Aspose.Cells.GridWeb control:
- Add the Aspose.Cells.GridWeb control to a web form.
- Import the Excel file by specifying the file path.
- Run the application.
If you don’t know how to add the control to a web form, refer to Add GridWeb to Web Form.
When Aspose.Cells.GridWeb control is added to a web form, the control is automatically instantiated and added to the form with a default size. You don’t have to create an Aspose.Cells.GridWeb control object. All you have to do is drag and drop the control and start using it.
However, to load the content from an Excel file into Aspose.Cells.GridWeb control, you have to call the ImportExcelFile method to specify the path of the Excel file. After that, Aspose.Cells.GridWeb control will automatically find the file from the specified path and display its contents. A code snippet that loads the contents of an Excel file is provided below.
The above code snippet can be used in any way you want. For example, to load an Excel file automatically when a web form loads, add this code to the form’s Page_Load event. If you want to open a file when a button is clicked, add a button to the web form and write the above code under the button’s Click event.
An Excel file is loaded when a button is clicked
If your file system is NTFS, you should grant read‑access permission to the ASPNET or Everyone user accounts, or you will get an access‑denied exception at runtime.
Import from Stream
As well as opening Excel files from a file, the Aspose.Cells.GridWeb control can load Excel files from a stream. Using a file as a stream is a better approach to avoid any file‑access or sharing‑violation problems because this approach ensures that all connections to the files are closed by closing the stream.