I'm currently writing a class to handle writing data to an Excel Spreadsheets using the Aspose Cells API. Writing the data out from a .NET DataTable seems to be the quickest method of doing this that I've found. To achieve this I am the tables XML to a longchar and reading it into a Syetem.Data.DataSet then extracting the table from there. This seemed to work however I have just noticed that fields with extents are ignoring when they are being read into the DataSet / DataTable.
Has anyone else had any issues with this or potentially knows a better method of doing it?
DEFINE VARIABLE oDataSet AS DataSet NO-UNDO.
DEFINE VARIABLE oDataTable AS DataTable NO-UNDO.
hTable:WRITE-XML("longchar", lcData, false, ?, ?, TRUE).
ASSIGN oDataset = NEW DataSet()
oDataTable = NEW DataTable().
oDataSet:ReadXml(NEW System.IO.StringReader(lcData), XmlReadMode:InferTypedSchema).
oDataTable = oDataSet:Tables.