hello,
I opened the excel file by using workbook.open() method...
Now i want to read the data from the excel file.. & save it into
array.
help out .. how to do this.
Then i want to pass that array through SetSourceData() method & want to draw cunztomized chart...
(I am using Excel 2007, C# 2005, COM)
Thx... :)
student491
Last Activity: Feb 26 '08, 06:33 PM
Joined: Jan 16 '08
Location:
-
How to read Excel file & save data in array...........
-
i used the followning fuctions But when i click the button ... nothNg is done ... ( means excel file didn't open).......... ..
tring workbookPath = "G:\\test.x ls"; // Add your own path here
Microsoft.Offic e.Interop.Excel .Workbook excelWorkbook = ThisApplication .Workbooks.Open (workbookPath, 0,
false, 5, "", "", false, Microsoft.Offic e.Interop.Excel .XlPlatform.xlW indows,... -
that problem of method z solved i gave the the wrong extention .. nw
problem z no file z opened ... nothNg z happened...
so plz help me out ...
(i'm usNg C#2005, Excel 2007 & COM)
thanksLeave a comment:
-
how to open Existing Excel file ....
Hello,
i tried to open existNg Excel file by using follow metho bt it give error ... that this file doestnt exist or path is incorrect...... ..
wb = ThisApplication .Workbooks.Open (paramWorkbookP ath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,...
No activity results to display
Leave a comment: