![]() ![]() The print setup options for the special sheet will be the same as those of the original sheet, in terms of paper size, orientation, header, footer, margins, etc. By capturing only printable data, file size is reduced, and the transmission of confidential data, formulas, links, or authorial secrets is avoided. The utility makes a special copy of a sheet, capturing only the data necessary to produce an identical printout or screen visualization of the original sheet. You also can uninstall it automatically using the same installer file, leaving no mess on your Windows Register or disc. Its setting is saved in PortblXLSPrinter.ini and PortblXLSPrinter.xlam files that are created and maintained by the proper utility. Except for the DLL, no other setting is saved in the Microsoft Windows® Register. It consists of only one file, the PortblXLSPrinter.dll, which is about 190 kb in size and can be installed automatically using one of the installer package files available below to download. All this made by user interface or by VBA code. Because it is spreadsheet, it allows greater editing flexibility if any changes or additions are necessary such as formatting, including text and formulas before being forwarded to a recipient who, in turn, can make changes and return with response data that can be captured to the original XL. It's most faithful to the original, because it is still a spreadsheet. Programs able to visualize basic XLS files are more widely installed than PDF viewers. The impression here to an Excel Portable XLS is similar to printing to an Adobe PDF, but with some advantages: This solution also avoids the unnecessary sending of copyrighted data or data hidden or filtered in the original XL file that may require privacy as a whole. It is also easy to share, because you can view it on any computer or cloud computing environment with a recent XLS viewer installed, even if the same Excel version used to create the original XL file is unavailable, avoiding the complications of formulas, filters, links, macros, etc. And, like any other file, you can email or transfer it using a CD, DVD, USB drive, or network connection. The generated XLS and the original look the same in print as they do on the screen, but the generated XLS is more portable, because it contains only the data necessary to produce the print-out. This utility is a COM add-in or add-in (.xla) programmed in Microsoft® Visual Basic® for Application (VBA) that makes it possible to generate an XLS (or XLSX) file from a sheet in an another XL file opened in Microsoft Excel® that summarizes only the printable data in the set print area. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |