Free Support Forum - aspose.com

Evaluation for Purchase Part III

Can we store Excel workbooks with an unlimited number of worksheets and can the user of the web app. Open up the stored spreadsheet and all information will display?

In your code samples, this was listed as a possible method to open a file: //Creating an Workbook object
Workbook workbook = new Workbook();


//Create a Stream object
FileStream fstream = new FileStream("C:\\book1.xls",FileMode.Open);


//Calling Open method of Workbook object to open the file from a Stream object
//that contains the content of file and it should support seeking
workbook.Open(stream);
If a file is stored on the web server, is it really this simple to open up a multiple - worksheet file in this manner?

The Sales department referred us to you and said you could provide a demonstration of saving a multiple-worksheet Excel file to the web server (with say a chart embedded in a worksheet) and then retrieving this same file from the web server. Would this be possible?

Hi,

Thanks for Considering Aspose.

Can we store Excel workbooks with an unlimited number of worksheets and can the user of the web app. Open up the stored spreadsheet and all information will display?

Well you may create any number worksheets in a workbook depending on your system configuration. The user of the web application can load any file in Excel or in his browser.

In your code samples, this was listed as a possible method to open a file: //Creating an Workbook object
Workbook workbook = new Workbook();

//Create a Stream object
FileStream fstream = new FileStream("C:\\book1.xls",FileMode.Open);


//Calling Open method of Workbook object to open the file from a Stream object
//that contains the content of file and it should support seeking
workbook.Open(stream);


Well absolutely that 's the code. where the Workbook represents the main root object. You may either open any excel file directly or through Stream

Please see: http://www.aspose.com/wiki/default.aspx/Aspose.Cells/OpeningFile.html

If a file is stored on the web server, is it really this simple to open up a multiple - worksheet file in this manner

Ofcourse yes.. you may open and save any spreadsheet file with any no. of worksheets.

The Sales department referred us to you and said you could provide a demonstration of saving a multiple-worksheet Excel file to the web server (with say a chart embedded in a worksheet) and then retrieving this same file from the web server. Would this be possible?

Please see our Chart Demos for the web:

http://www.aspose.com/Products/Aspose.Cells/Demos/ChartDemos.aspx

Regards

Amjad Sahi

Aspose Nanjing Team

Actuall MS Excel limits the number of worksheets: it only allows 65536 worksheets in a workbook. And it's also limited by the memory size on your machine.

Please check the demos source code after you install Aspose.Cells. It includes code to open a multiple-worksheet file on the web server and creates multiple-worksheet file with chart. However, it only includes code to save files to client browser and save files to disk in a winform application. It doesn't provide code to save file on web server because you have to assign write right to a folder for an aspnet application. Our setup program cannot make it.

To save a file on web server, please assign enough right first, then call Workbook.Save method to save file on disk.