You can''t read client side xls files?

I'm thinking about this product, but in that other post you're saying you can't read in client side files, that you have to stream them from the server. Is this true?

For my application, I need to read in files on the client machine, manipulate them, page size, margins, layout.. all of which you support. But I need to be able to read and write the files on the client machine. I don't want to go through the server? Is this true with the excel reader too? can you only stream files from the server?


2 Replies

DA dan August 15, 2011 12:29 AM UTC

I looked at your samples and it read in a local file no problem. Was that other post outdated? I shouldn't have any problems doing everyone on the client right? I just used:

OpenFileDialog dialog = new OpenFileDialog();
dialog.Multiselect = false;
dialog.Filter = "xls (*.xls) |*.xls";
int i = 0;

if ((bool)dialog.ShowDialog())
{
FileStream fs = dialog.File.OpenRead();
ExcelEngine engine = new ExcelEngine();
IWorkbook book = engine.Excel.Workbooks.Open(fs, ExcelOpenType.Automatic);
IWorksheet sheet = book.Worksheets[0];

... loop through cells or whatever



SR Sridhar Syncfusion Team August 17, 2011 07:15 AM UTC

Hi Dan,

Thank you very much for using Syncfusion products.

When reading the xls file from server to client we need to read as an stream and manipulate the changes in the worksheet.And we cant read as the files.

Please let us know the actual requirement you are trying at our side so that we can provide the details for the same.

Please udpate us the the platform used for client server application and the simplified sample to proceed further.


Thanks,
Sridhar.S


Loader.
Up arrow icon