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);
}
}