Free Support Forum - aspose.com

System.FormatException was unhandled

Greetings,

I am using Aspoce.Cells 4.8.1 eval version. I am trying the examples to open an Excel 2007 file with over 2700 columns in it.
The systems errors out with the following message:

System.FormatException was unhandled
Message="Input string was not in a correct format."
Source="mscorlib"
StackTrace:
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at System.Int32.Parse(String s)
at xabb58b8f2887ff8e.x7661ca2b53df3da9.xd9c6f1ce6ced5eb4(XmlTextReader xb9763b0038341e6c)
at xabb58b8f2887ff8e.x7661ca2b53df3da9.x5b9fbbb55c31a1b7(XmlTextReader xb9763b0038341e6c)
at xabb58b8f2887ff8e.x7661ca2b53df3da9.x06b0e25aa6ad68a9(XmlTextReader xb9763b0038341e6c)
at xabb58b8f2887ff8e.x9d49ab444acbddce.x72bde2882aefe5af(x1f5f0dd7560ed867 xd9171314ec0b2957, String x7d11dcd405070662)
at xabb58b8f2887ff8e.x9d49ab444acbddce.xc3266f78bb6c4216(x1f5f0dd7560ed867 xd9171314ec0b2957, String x7d11dcd405070662)
at xabb58b8f2887ff8e.x9d49ab444acbddce.x88ae89d546ee9fdf()
at xabb58b8f2887ff8e.x9d49ab444acbddce.x06b0e25aa6ad68a9()
at xabb58b8f2887ff8e.xe95a61e48a6637a3.x2e7f798eabefe5b4(Workbook xce16031e3118b903, Stream xcf18e5243f8d5fd3)
at Aspose.Cells.Workbook.Open(Stream stream, FileFormatType type)
at Aspose.Cells.Workbook.Open(String fileName)
at Driver.Starter.Main(String[] args) in C:\Projects\QA Utility\Driver\Starter.cs:line 26
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:

This is my code:
License license = new License();
license.SetLicense(@"C:\Program Files\Aspose\Aspose.Cells for .NET\Bin\Net2.0\Aspose.Cells.lic");
Workbook workbook = new Workbook();
workbook.Open(@"C:\Documents and Settings\ejuarez\My Documents\2007 Version\Inputs Test Cases 10_23_2009.xlsx"); Cells cells = workbook.Worksheets[0].Cells;

Console.WriteLine("Rows: " + cells.Rows.Count + " Columns: " + cells.Columns.Count);

Do you have any idea what the exception means?

Thanks,
Efrain Juarez


This message was posted using Aspose.Live 2 Forum

Hi,

Thank you for considering Aspose.

Please post your template file here to reproduce the issue and we will check it soon.

Thank You & Best Regards,

Greetings,

Thanks for your quick response.

I tried using "workbook.Open(@"test.xlsx", FileFormatType.Excel2007Xlsx);" but still it does not work.
Attached is the xlsx file I want to read.

Thanks.

Hi,

Thank you for considering Aspose.

We have found your mentioned issue after an initial test. We will look into it and get back to you soon. Your issue has been registered in our issue tracking system with issue id CELLSNET-11870.

Thank You & Best Regards,

Hi,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have fixed your mentioned issue.

Thank You & Best Regards,

The issues you have found earlier (filed as 11870) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan