Morning.
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?
Thanks,
Kim
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[0].