p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

csharptoday_discuss thread: C# .NET and Microsoft Excel


Message #1 by "lim siew ling" <siew-ling.lim@b...> on Tue, 29 Oct 2002 03:43:12
I have a simple c# component which actually read the Excel Spreedsheet and 
store the contain into an array.
I'm referencing the Microsoft Excel 9.0 Object Library in my C# 
componenet. 

It work OK when i using the C# sample program to call the component but it 
not able to read the excel file when i using the ASP.NET.
The error message "Access is denied" is show when i using the ASP.NET to 
call the component.

I have try to open and read the same excel file only using ASP.NET by 
using SELECT * FROM [SHEET1] and able to read the Spreedsheet contains.
It open and read the file successfully. When i bind the dataSet from the 
Excel spreadsheet to the DataGrid, it show all the contains in the 
DataGrid.
But it not show the complete DataSet contain when i try to print the 
dataset contain in xml format using 

    Response.write(ds.getxml()).

Have anyone of you have  experience this problem before? please advice. 
Thanks.

Regard 
LSL

  Return to Index