reading non text files in vb.net
-
hi i want to read an xls file from vb.net and then write it to a text file.. obviously using streamreader gives me garbled output..is it possible to get meaningful data or am i wasting my time? a few pointers please??
-
hi i want to read an xls file from vb.net and then write it to a text file.. obviously using streamreader gives me garbled output..is it possible to get meaningful data or am i wasting my time? a few pointers please??
in fact im more interested in getting the macro code from excel files..wat i mean is i am interested in reading the macro code for some purposes. -- modified at 8:43 Friday 12th January, 2007
-
in fact im more interested in getting the macro code from excel files..wat i mean is i am interested in reading the macro code for some purposes. -- modified at 8:43 Friday 12th January, 2007
You're pretty much wasting your time using a StreamReader, of any other file operation. Office files, prior to Office 12, used a multiple-stream format that was very difficult to decode manually. Your only hope is to use Automation to start an Excel instance, have it load the XLS file, then you can use the automation interface to get that scripts you want. No, I don't have any examples.
Dave Kreskowiak Microsoft MVP - Visual Basic
-
You're pretty much wasting your time using a StreamReader, of any other file operation. Office files, prior to Office 12, used a multiple-stream format that was very difficult to decode manually. Your only hope is to use Automation to start an Excel instance, have it load the XLS file, then you can use the automation interface to get that scripts you want. No, I don't have any examples.
Dave Kreskowiak Microsoft MVP - Visual Basic
thanks..
-
hi i want to read an xls file from vb.net and then write it to a text file.. obviously using streamreader gives me garbled output..is it possible to get meaningful data or am i wasting my time? a few pointers please??
i got a solution..i automated excel to export the macros,which i could read easily as any normal text files..:cool: