Reply to topic  [ 2 posts ] 
Reading worksheet as Dataset 
Author Message

Joined: Tue Apr 29, 2008 8:50 am
Posts: 1
Reply with quote
Post Reading worksheet as Dataset
One thing we have noticed in our trial version testing. While reading excel worksheet as dataset if the worksheet has columns with formula then EasyXLS brings back #VALUE! into dataset.

I can see correct values appearing in the formula columns but still EasyXLS through “Error processing formula: any formula text, Unable to cast object of type System.String to type EasyXLS.Formulas.Util.FunctionDataObject”

This error occurs when following lines of code executes:
Code:
ExcelWorksheet xlsWorkSheet = (ExcelWorksheet)xls.easy_getSheet(workSheetName);

DataSet tempDS = xls.easy_ReadExcelWorksheet_AsDataSet(xlsWorkSheet);



Please advice why do we get #VALUE !even though we have correct formula value e.g. value 12 appearing in the formula column.


Cheers
Bhavesh


Tue Apr 29, 2008 8:53 am
Profile

Joined: Fri Jun 13, 2008 3:16 am
Posts: 1
Reply with quote
Post 
Hi
I also have the same problem
I found that if one of the cell value is a number with some space character,it will return that error.
for example:
A1 = A2+A3+A4
if A3's real value is " 123"
when I ReadExcelWorksheet_AsDataSet
the A1 cell will be #VALUE !
but in Office2003 ,the A1 can still do the calculation correctly
it's not easy to find out.
I hope EasyXLS can fix this quickly


Fri Jun 13, 2008 3:33 am
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 2 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.