Hi,
Is it possible to read a XML file using Aspose?
Thanks
This message was posted using Aspose.Live 2 Forum
Hi,
Is it possible to read a XML file using Aspose?
Thanks
Hi Vineet,
An XML file can be read to fill a datatable/dataset using ADO.NET APIs and then import the datatable to the worksheet using Aspose.Cells APIs.
Sample code is as follows,
Hi Vineet,
Aspose.Cells for .Net also supports reading / writing SpreadSheetML (.xml) files directly. SpreadSheetML files are the XML representations of Spreadsheets including all information about the Spreadsheet such as formatting, formulae etc.
You can read a SpreadSheetML file through sample code as given below,
How to find out if XML is an spreadsheet representation?
I just have a XML file and I don't know if it is an spreadsheetML. Please advise.
Also, I want the way to read XML using Aspose.Cells for Java and not DotNet.
Hi,
We have a class CellsHelper.DetectFileFormat() in Aspose.Cells for .NET version, which can identify the file format. e.g
But when I looked into Aspose.Cells for Java version, this class is not available.
So, I have added a request for it CELLSJAVA-25400.
Hi,
Please try Aspose.Cells for Java v2.5.2.8.
In the new fix we have provided new methods:
CellsHelper.detectFileFormat(InputStream) and CellsHelper.detectFileFormat(String file)
Thank you.
The issues you have found earlier (filed as 25400) have been fixed in this update.