Last post Mar 12, 2011 07:39 AM by krisrajz
Participant
1042 Points
658 Posts
Mar 11, 2011 02:50 AM|krisrajz|LINK
I am using ExcelLibrary (http://code.google.com/p/excellibrary/) to read excel files uploaded in the server
It seems working fine except if number of characters reach 192 .... seems it is because of UTF-8 having some restriction at 192,193
Any help would be appreciated
Regards Raj
All-Star
28988 Points
7251 Posts
Mar 12, 2011 01:05 AM|Rajneesh Verma|LINK
Alternatively you can use:
http://www.dotnetcurry.com/ShowArticle.aspx?ID=138
http://www.dotnetspider.com/resources/15591-How-read-EXCEL-data-file-asp-net.aspx
http://forums.asp.net/t/1102652.aspx/1?Read+Excel+file+in+asp+net
Member
112 Points
234 Posts
Mar 12, 2011 01:23 AM|NewProgramer|LINK
waoo i also need this code and it works perfectly
thanks
Mar 12, 2011 07:39 AM|krisrajz|LINK
I have an issue, name of sheet getting changed for different sheets.
Since sheet name is not fixed, I cannot use like "select * from [Sheet1$]"
Is there any way to read all the sheets in a workbook without knowing sheet names?!
Participant
1042 Points
658 Posts
Excel file reading
Mar 11, 2011 02:50 AM|krisrajz|LINK
I am using ExcelLibrary (http://code.google.com/p/excellibrary/) to read excel files uploaded in the server
It seems working fine except if number of characters reach 192 .... seems it is because of UTF-8 having some restriction at 192,193
Any help would be appreciated
Regards
Raj
Raj
Remember to click Mark as Answer on the post that helps to others.
All-Star
28988 Points
7251 Posts
Re: Excel file reading
Mar 12, 2011 01:05 AM|Rajneesh Verma|LINK
Alternatively you can use:
http://www.dotnetcurry.com/ShowArticle.aspx?ID=138
http://www.dotnetspider.com/resources/15591-How-read-EXCEL-data-file-asp-net.aspx
http://forums.asp.net/t/1102652.aspx/1?Read+Excel+file+in+asp+net
www.rajneeshverma.com
Member
112 Points
234 Posts
Re: Excel file reading
Mar 12, 2011 01:23 AM|NewProgramer|LINK
waoo i also need this code and it works perfectly
thanks
Participant
1042 Points
658 Posts
Re: Excel file reading
Mar 12, 2011 07:39 AM|krisrajz|LINK
I have an issue, name of sheet getting changed for different sheets.
Since sheet name is not fixed, I cannot use like "select * from [Sheet1$]"
Is there any way to read all the sheets in a workbook without knowing sheet names?!
Raj
Remember to click Mark as Answer on the post that helps to others.