I am evaluating Aspose.Excel and am attempting to use SmartMarkers to load data to a spreadsheet. I have successfully gotten the data into the spreadsheet, but integer data imported via this method shows the "number stored as text" warning. I am aware that I can turn off this warning from the Excel Options page, but would rather have the value stored as a "number" value automatically.
I also have worked with the Aspose.Excel api call cell.PutValue() and know that using this api, I can cause the value to be converted to a different type by adding the "true" parameter.
Is there a way that this type of functionality can be accessed using the SmartMarker technique?
Thanks,
Pam