There are two excel files I have that I can not import into a gridview, I really need to open them up in an Excel window after I get done updating them. Is there a way to safely open an excel window using aspose? I can't get to seem to make it work using asp.net directly.
Hi,
Thanks for your query.
1) Aspose.Cells for .NET has Aspose.Cell library (Aspose.Cells.dll),
this is a powerful component to be used to manipulate existing Excel files and create new ones
from scratch. You can retrieve user input
and after creating excel file, you will send it to users to open it into user’s Excel. A download dialog box is shown on the client’s browser and he needs to click on “Open” button to open the file into his MS Excel or Excel viewer. See the sample code:
e.g
//Creating an Workbook object
Workbook workbook = new Workbook(filePath);
//… do something here
//Save in default format and send the file to user so that he may open the file in
//some application or save it to some location
workbook.Save(this.Response, “Report.xls”, ContentDisposition.Attachment, new XlsSaveOptions());
2) Aspose.Cells GridWeb - An Asp.NET control provided by Aspose.Cells for .NET, it has a GUI interface the users can do all things (editing/updating data) in WYSIWYG (visual). See the online demos.
Thank you.