public static XElement ConvertTableToHtml(SpreadsheetDocument sDoc, SmlToHtmlConverterSettings settings, string tableName) { var rangeXml = SmlDataRetriever.RetrieveTable(sDoc, tableName); var xhtml = SmlToHtmlConverter.ConvertToHtmlInternal(sDoc, settings, rangeXml); return(xhtml); }
// *********************************************************************************************************************************** #region PublicApis public static XElement ConvertTableToHtml(SmlDocument smlDoc, SmlToHtmlConverterSettings settings, string tableName) { using (MemoryStream ms = new MemoryStream()) { ms.Write(smlDoc.DocumentByteArray, 0, smlDoc.DocumentByteArray.Length); using (SpreadsheetDocument sDoc = SpreadsheetDocument.Open(ms, false)) { var rangeXml = SmlDataRetriever.RetrieveTable(sDoc, tableName); var xhtml = SmlToHtmlConverter.ConvertToHtmlInternal(sDoc, settings, rangeXml); return(xhtml); } } }
public void Sample1() { var fi = new FileInfo(GetFilePath("SampleSpreadsheet.xlsx")); // Retrieve range from Sheet1 var data = SmlDataRetriever.RetrieveRange(fi.FullName, "Sheet1", "A1:C3"); Log.WriteLine(data.ToString()); // Retrieve entire sheet data = SmlDataRetriever.RetrieveSheet(fi.FullName, "Sheet1"); Log.WriteLine(data.ToString()); // Retrieve table data = SmlDataRetriever.RetrieveTable(fi.FullName, "VehicleTable"); Log.WriteLine(data.ToString()); }
private static void Main() { var fi = new FileInfo("../../SampleSpreadsheet.xlsx"); // Retrieve range from Sheet1 var data = SmlDataRetriever.RetrieveRange(fi.FullName, "Sheet1", "A1:C3"); Console.WriteLine(data); // Retrieve entire sheet data = SmlDataRetriever.RetrieveSheet(fi.FullName, "Sheet1"); Console.WriteLine(data); // Retrieve table data = SmlDataRetriever.RetrieveTable(fi.FullName, "VehicleTable"); Console.WriteLine(data); }
static void Main(string[] args) { FileInfo fi = null; fi = new FileInfo("../../SampleSpreadsheet.xlsx"); // Retrieve range from Sheet1 XElement data = SmlDataRetriever.RetrieveRange(fi.FullName, "Sheet1", "A1:C3"); Console.WriteLine(data); // Retrieve entire sheet data = SmlDataRetriever.RetrieveSheet(fi.FullName, "Sheet1"); Console.WriteLine(data); // Retrieve table data = SmlDataRetriever.RetrieveTable(fi.FullName, "VehicleTable"); Console.WriteLine(data); }
public void SH003_ConvertTable(string name, string tableName) { FileInfo sourceXlsx = new FileInfo(Path.Combine(TestUtil.SourceDir.FullName, name)); var sourceCopiedToDestXlsx = new FileInfo(Path.Combine(TestUtil.TempDir.FullName, sourceXlsx.Name.Replace(".xlsx", "-1-Source.xlsx"))); if (!sourceCopiedToDestXlsx.Exists) { File.Copy(sourceXlsx.FullName, sourceCopiedToDestXlsx.FullName); } var dataXmlFi = new FileInfo(Path.Combine(TestUtil.TempDir.FullName, sourceXlsx.Name.Replace(".xlsx", "-2-Generated-XmlData.xml"))); using (SpreadsheetDocument sDoc = SpreadsheetDocument.Open(sourceXlsx.FullName, true)) { var settings = new SmlToHtmlConverterSettings(); var rangeXml = SmlDataRetriever.RetrieveTable(sDoc, tableName); rangeXml.Save(dataXmlFi.FullName); } }