예제 #1
0
        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\" />" };
                html.Export(Path.Combine(await TempHtmlPathString(), TempHtmlName), ".");
            }
        }
예제 #2
0
        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);
        }