A
apondu
hi,
I am a student working on a project for my academics. I am working
on parsing the the files such as .doc, .xls, .ppt,.pps.
I am facing problem during the extraction of text from the excel
sheet. I am specifying the range of the working cells in the worksheet
manually and it takes time and sometimes there is loss of data if the
range is more in the worksheet than i had specified so i wanted to know
whether there is any function which would automatically calculate the
range of the worksheet.
I am even facing a problem when the format of the cell is changed to
say date rather than general, the extracted cell content is different
from the content which is actually stored
for eg. : if the stored content is 02-Feb-06 then the extracted content
would be say something like 32761. I wanted to know the reason for this
and also the solution.
I am using C#.Net and office 11 object library for my project. It
would be very helpful if u could provide some code snippets too. Thank
you in advance for the help.
I am a student working on a project for my academics. I am working
on parsing the the files such as .doc, .xls, .ppt,.pps.
I am facing problem during the extraction of text from the excel
sheet. I am specifying the range of the working cells in the worksheet
manually and it takes time and sometimes there is loss of data if the
range is more in the worksheet than i had specified so i wanted to know
whether there is any function which would automatically calculate the
range of the worksheet.
I am even facing a problem when the format of the cell is changed to
say date rather than general, the extracted cell content is different
from the content which is actually stored
for eg. : if the stored content is 02-Feb-06 then the extracted content
would be say something like 32761. I wanted to know the reason for this
and also the solution.
I am using C#.Net and office 11 object library for my project. It
would be very helpful if u could provide some code snippets too. Thank
you in advance for the help.