blog.softartisans.comSoftArtisans Blog: Tech Insights, Reviews, and Webinars

SoftArtisans Search Primary MenuAbout Tech Retro Tech Women In Tech Truth in Tech ASP.NET Excel Big Data Events OfficeWriter Knowledge Base ExcelWriter Knowledge Base WordWriter Knowledge Base Webinars News Releases Reviews SoftArtisans Meet the Team Intern Diaries Search for: Featured , OfficeWriter , Reporting Services , Reviews , SQL Server , SSRS [Review] Pinal Dave from SQLAuthority.com Enterprise Software , ExcelWriter , Featured , News Releases , OfficeWriter , PowerPointWriter What’s New in OfficeWriter 9 OfficeWriter , PowerPointWriter VP of Development Talks PowerPointWriter Uncategorized How to Use PageSetup Options When Saving to a PDF Document May 25, 2016 Richard When saving Excel worksheets to a PDF document using the PDF rendering extension methods introduced in OfficeWriter 10.0, it is often useful to be able to specify details about the resulting PDF document, or about how the rendering should behave. This is achieved by setting properties on the worksheet’s PageSetup property before calling the SavePdf method. This tutorial will walk through that process. Setting up your worksheet For this example, we will open an existing workbook, in order to save the first worksheet of the workbook to a PDF document: ExcelApplication xla = new ExcelApplication () ; Workbook WB = xla.Open( input.xlsx” ); Worksheet worksheetToSave = WB[0]; Specifying page properties Using the worksheet’s PageSetup property, we can specify the page size, orientation, and margins. These properties will be reflected in the final PDF document: worksheetToSave.PageSetup.PaperSize = PageSetup.PagePaperSize .Legal; worksheetToSave.PageSetup.Orientation = PageSetup.PageOrientation .Landscape; worksheetToSave.PageSetup.TopMargin = 1.5; // Specified in inches Setting a header and footer The PageSetup property can also be used to set a header or footer. The header and footer will be printed on each page of the PDF: HeaderFooterSection.Section hfSection = HeaderFooterSection.Section .Center; worksheetToSave.PageSetup.GetHeader(hfSection).SetContent( Header text” ); Specifying rendering options Other PageSetup properties are useful for specifying how the content should be rendered to the PDF document. For example, we can make the content smaller than normal by using the Zoom property, specify the order in which pages should appear in the PDF document, and print all of the cell comments at the end of the document by setting the relevant properties on the worksheet: worksheetToSave.PageSetup.Zoom = 50; // Specified as a percentage worksheetToSave.PageSetup.UseZoom = true ; worksheetToSave.PageSetup.PrintOrder = PageSetup.PagePrintOrder .DownThenOver; worksheetToSave.PageSetup.PrintComments = true ; worksheetToSave.PageSetup.PrintCommentsAtEnd = true ; There are additional PageSetup properties that may prove useful; for a complete list, see the PageSetup documentation. Saving the PDF document Once you have set all desired PageSetup options, you can then save the worksheet to a PDF document: worksheetToSave.SavePdf( output.pdf” ); If you want to save multiple PDF documents from the same workbook, but with different options set, you can repeat this process. For example, after saving one PDF document, you could then change the PaperSize property to a different size of paper, and then save a second document. The updated properties will be reflected in any subsequent calls to SavePdf. When saving an entire workbook to a PDF, each worksheet is rendered using its own PageSetup properties. Follow ASP.NET , ExcelWriter , Knowledge Base , OfficeWriter , Programming Save PDF file to HttpResponse April 15, 2016 Richard In a previous blog post we discussed how OfficeWriter 10.0 introduced the ability to save an Excel workbook to a PDF document. When working in a web environment it is common to want to send the generated file to the browser for your end user to download and view on their own machine. Step 1: Generate your workbook. A very simple example might be: var xla = new ExcelApplication(); var wb = xla.Create(ExcelApplication.FileFormat.Xlsx); var ws = wb[0]; ws.Cells[0, 0].Value = "Hello"; ws.Cells[0, 1].Value = "World!"; Step 2: Define a helper method to write the file byte to the current response stream: public static void WriteFileToResponse (HttpContext context, byte[] bytes, string fileName) { var bytesLength = bytes.Length.ToString(CultureInfo.InvariantCulture); var response = context.Response; response.Clear(); response.Buffer = true; response.AddHeader("Content-Length", bytesLength); response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); response.ContentType = MimeMapping.GetMimeMapping(fileName); response.BinaryWrite(bytes); response.Flush(); response.End(); } Step 3: Save the PDF to a memory stream and call our helper method we just defined. This has the benefit of avoiding disk IO. This may vary if your application actually needs to persist the generated PDF. using (var memoryStream = new MemoryStream()) { var fileName = "generatedfile.pdf"; wb.SavePdf(false, memoryStream); memoryStream.Seek(0, SeekOrigin.Begin); WriteFileToResponse(HttpContext.Current, memoryStream.ToArray(), fileName); } And that’s it! Follow excelwriter HttpResponse OfficeWriter Pdf ExcelWriter , Knowledge Base , OfficeWriter How to Save an Excel Workbook to a PDF Document March 29, 2016 Richard OfficeWriter 10.0 introduces the ability to save a Workbook, Worksheet, or Area to a PDF document. This makes it possible to produce a searchable, vector-format rendering of your spreadsheet. Using the Imaging Extension DLL The PDF functionality is included in the rendering extensions DLL (SoftArtisans.OfficeWriter.ExcelWriter.Imaging.dll). The first thing you will need to do is include this DLL as a reference in your project in Visual Studio. You will also need to tell the compiler to use the imaging namespace in your source file. This can be accomplished by adding a using statement to the top of the file where you want to save a PDF document: using SoftArtisans.OfficeWriter.ExcelWriter.Imaging; Setting up your workbook In order to save an Excel workbook to a PDF document, you first need a workbook with contents in it. For this example, let’s create a simple workbook with three worksheets: ExcelApplication xla = new ExcelApplication (); Workbook WB = xla.Create( ExcelApplication.FileFormat .Xlsx); Worksheet ws0 = WB[0]; Worksheet ws1 = WB.Worksheets.CreateWorksheet( "Sheet2" ); Worksheet ws2 = WB.Worksheets.CreateWorksheet( "Sheet3" ); ws0[0, 0].Value = Sheet 1, Cell A1” ; ws1[0, 0].Value = Sheet 2, Cell A1” ; ws2[0, 0].Value = Sheet 3, Cell A1” ; For this example, we are just exporting some cells with text in them. However, the rendering extensions support more dynamic content as well, such as cell formatting, charts, images, comments, or conditional formats. We could also use a workbook that we opened from a file, that already had contents and formatting applied. Saving a PDF document There are three ways to save a PDF document: through the workbook, through a worksheet, or through a specific area. Specific PDF rendering options can be specified by setting a worksheet’s PageSetup properties; this will be covered in a later tutorial. If you have not set any of the worksheet’s PageSetup properties, then default settings will be used. You can save multiple PDF files from one workbook. First, let’s save multiple worksheets to a single PDF document. This can be achieved by using the Workbook.SavePdf method. The first parameter is a Boolean; if this is set to true, then only selected worksheets will be saved. Otherwise all visible worksheets will be saved. For this example, lets save the first and the third worksheet to a single PDF document. Continuing from the code above, we can achieve this with the following two lines of code: WB.Worksheets.Select( new object []{0, 2}); WB.SavePdf( true , MultipleWorksheets.pdf” ); We can also save the remaining worksheet to a...