private void btnExportHtml_Click(object sender, System.EventArgs e)
{
string MainHtmlPath = Path.Combine(ResultPath, "featuresflexcel.htm");
using (DataSet data = LoadDataSet())
{
XlsFile Xls = Export(data);
Directory.CreateDirectory(ResultPath);
using (FlexCelHtmlExport html = new FlexCelHtmlExport(Xls, true))
{
html.ImageResolution = 192;
html.ImageBackground = Color.White; //Since we are not setting html.FixIE6TransparentPngSupport, we must ensure tehre are no transparent images.
TStandardSheetSelector SheetSelector = new TStandardSheetSelector(TSheetSelectorPosition.Top);
SheetSelector.SheetSelectorEntry += new SheetSelectorEntryEventHandler(SheetSelector_SheetSelectorEntry);
SheetSelector.CssGeneral.Main += "font-family:Verdana;font-size:10pt;";
html.ExportAllVisibleSheetsAsTabs(ResultPath, "Features", ".htm", null, null, SheetSelector);
//Rename the first tab so it is "featuresflexcel.htm";
string[] Sheets = html.GeneratedFiles.GetHtmlFiles();
File.Delete(MainHtmlPath);
File.Move(Sheets[0], MainHtmlPath);
}
}
if (MessageBox.Show("Do you want to open the generated file?", "Confirm", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Process.Start(MainHtmlPath);
}
}
async Task GenerateHTML(ExcelFile xls)
{
using (FlexCelHtmlExport html = new FlexCelHtmlExport(xls, true))
{
html.SavedImagesFormat = THtmlImageFormat.Svg; //vectorial so it can zoom.
html.EmbedImages = true;
//see http://blogs.windows.com/windows_phone/b/wpdev/archive/2011/03/14/managing-the-windows-phone-browser-viewport.aspx
html.ExtraInfo.Meta = new string[] { "<meta name=\"viewport\" content=\"width=device-width\" />" };
await html.ExportAsync(await TempHtmlPath(), TempHtmlName, ".");
}
}
void GenerateHTML(ExcelFile xls)
{
using (FlexCelHtmlExport html = new FlexCelHtmlExport(xls, true))
{
//If we were using png, we would have to set
//a high resolution so this looks nice in high resolution displays.
//html.ImageResolution = 326;
//but we will use SVG, which is vectorial:
html.HtmlVersion = THtmlVersion.Html_5;
html.SavedImagesFormat = THtmlImageFormat.Svg;
html.EmbedImages = true;
html.Export(TempHtmlPath, ".");
}
}
public MemoryStream Export(XlsFileExBase xls)
{
xls.ActiveSheet = 1;
var destStream = new MemoryStream();
if (AdapterType == TExportExcelAdapterType.toXLS || AdapterType == TExportExcelAdapterType.toXLSx)
{
xls.Save(destStream, AdapterType == TExportExcelAdapterType.toXLS ? TFileFormats.Xls : TFileFormats.Xlsx);
}
if (AdapterType == TExportExcelAdapterType.toHTML)
{
var temps = new MemoryStream();
var htmlExport = new FlexCelHtmlExport(xls, true);
var strHtmlColor = ColorTranslator.ToHtml(_htmlDocBkColor);
var s = new string[1];
s[0] = "<body bgcolor=" + strHtmlColor + ">";
htmlExport.ExtraInfo.BodyStart = s;
using (var sw = new StreamWriter(temps))
{
htmlExport.Export(sw, "", null);
sw.Flush();
var b = temps.ToArray();
destStream.Write(b, 0, b.Length);
}
}
//----- PDF ---
if (AdapterType == TExportExcelAdapterType.toPDF)
{
xls.PrintLandscape = false;
using (var pdfExport = new FlexCelPdfExport(xls, true))
{
pdfExport.Export(destStream);
}
}
destStream.Position = 0;
return(destStream);
}
