Excel Transformation

Office Server Document Converter V7.0 converts workbook files created in Microsoft Excel 97 to 2019 into PDF or SVG. This version also supports conversions into JPEG, PNG, TIFF or Multi-page TIFF. Most Excel chart features can be converted.

Transformation Specification

MS Excel Document

Office Server Document Converter V7.0 supports documents created in the following Excel programs:

  • ".xls" extension files files created with:
    Microsoft Excel 97 for Windows
    Microsoft Excel 2000
    Microsoft Excel 2002
    Microsoft Excel 2003
    Microsoft Office Excel 2007
    Microsoft Office Excel 2010
    Microsoft Office Excel 2013
    Microsoft Office Excel 2016
    Microsoft Office Excel 2019
  • ".xlsx" and ".xlsm" and ".xltx" and ".xltm" extension files created with:
    Microsoft Office Excel 2007 / 2010 / 2013 / 2016 / 2019

Transformation Specification

  • The program targets sheets in order (first to last), and generates pages for print according to the size of the paper and the expansion reduction rate specified by "Page Setup" for each sheet.
  • Sheets with no data are disregarded.
  • When a sheet has data only in the lower right cell, a blank page is outputted until it reaches that cell.
  • When a "Print Area" has been specified in a MS Excel sheet, only the data in the range of the print area are targeted to generate pages for print.
  • This program renders independently of Microsft Excel so even though cell format, row height, and column width in this program are designed to simulate those of Excel, results may not be exactly the same.
  • Charts will simulate Excel excluding 3D View.
  • Raster images are allocated as it is.
  • Although for the most part, Autoshape is processed by simulating the original, some shapes might output differently or not at all.

Excel Contol function for column width and line height

xls-rowcol-control function

– Excel Control function for column width and line height by users –

It's a function to adjust the column width and the cell height from outside the program. By specifying the scaling ratio, it's possible to adjust the range of the cell to fit into 1 page.

By specifying the key information saved in the Excel file and the adjustment value to the key, it is made available to make adjustment to the file by users. It's also possible to write and read multiple settings in a file as a parameter set and read. It's also possible to adjust in block without using the key.

The key information means the default font and the printer name saved in the Excel file. The default font is a font set to the cell when creating a new Excel sheet, which also is a base when calculating the table header or column width. One default font is set to a Excel workbook (file). Printer name indicates the printer used for printing set to each sheet.

The target default font and printer name are the one saved in the Excel file respectively. Please note that a printer name isn't sometimes preserved. Even when not preserved, the printer name is displayed when opening the printer related menu in Excel, it's not the printer name saved in the file but the name set to the system.

The size of the column width fluctuates by the difference of the default fonts. By changing the printer, the size may differ, so additional keys are adopted. But there aren't so much situation to use a printer name. By specifying the scaling ratio to the key, the cell included in the page can be adjusted. In addition, we offer the feature to return the default font and printer name as the information when loading. The information can be obtained in the same format as the error message, so you can refer to it when specifying the key.

Parameter set file

Prepare the file with the following description and pass it to the program. You can adjust the line height and column width by specifying the adjustment value when converting the file with the key specified.

<xls-rowcol-controls>
<xls-rowcol-control>
<xls-key>
<printer-name>Printer Name</printer-name>
<font name="Font Name" size="Font Size"/>
</xls-key>
<xls-key> ... </xls-key>
:
<xls-parameter row="Line height adjustment value" col="Column width adjustment value"/>
</xls-rowcol-control>
</xls-rowcol-controls>

DTD

<!ELEMENT xls-rowcol-controls (xls-rowcol-control*)>

<!ELEMENT xls-rowcol-control (xls-key*,
xls-parameter? ) >

<!ELEMENT xls-key (printer-name?,
font? ) >

<!ELEMENT printer-name (#PCDATA) >

<!ELEMENT font EMPTY >
<!ATTLIST font name CDATA #IMPLIED
size CDATA #IMPLIED >

<!ELEMENT xls-parameter EMPTY >
<!ATTLIST xls-parameter row CDATA #IMPLIED
col CDATA #IMPLIED >

Parameter description

  • xls-rowcol-control : 1 set of the adjustment value. Multiple values can be written in a file. They are verified in description order.
  • xls-key : Specifies the key to decide the target element (record) written in a file.
    • Multiple values can be written in xls-rowcol-control. They are verified in description order.
    • The adjustment value is adopted when it matches the target element (record) described in the file.
  • printer-name : Printer name (possible to specify the wild card). It's compared with the printer name in the printer information stored in the file.
    • Example : "EPSON LP-S310" (Includes the registered product name), "EPSON *" (General EPSON Printers)
  • font : Font information. It's compared with the default font information stored in the file.
    • name : Font name (possible to specify the wild card). It's compared with the default font name.
      Example : "IPA*" (Font beginning with IPA), "MS P Gothic"
    • size : Font size (enumerated values by the delimiter ',', range specification by '-' are available). It's compared with the default font size. (in units of point)
      Example : 8 (8pt), 10-15 (from 10pt to 15pt), 8,10 (8pt and 10pt), -10 (equal to or less than 10pt), 20- (equal to or greater than 20pt), 8, 14- (8pt and equal to or greater than 14pt)
  • xls-parameter : A set of adjustment value. only one can be written in xls-rowcol-control.
    • row : line height adjustment value : The scaling ration with % is given. (90%)
    • col : column width adjustment value : The scaling ration with % is given. (90%)

Usage Note

  • Multiple xsl-key can be specified to one xls-rowcol-control. Even if one matches, it will be adopted.
  • xls-rowcol-control is detected from the head in sequence. The detection ends when the matched set is found.
    • If the matched set is not found, (including the case where there is no xls-row-control) the processing will be performed without using the user's adjustment.
    • When the xlsinfoview option is specified, a message saying there is no matched set will be displayed.
  • If the setting by xls-key is omitted, the key is considered that its condition matches when detecting.
    • When there is no settings to the key at all, it is considered as their conditions match in all files and the following parameter settings will be effective. If such a key is written at the beginning, the latter settings are all ignored.
  • When the setting is omitted in xls-parameter, the omitted items are considered as 100% is specified.
    • When there is no settings to the items at all, it is considered as 100% is specified as the parameter value, the adjustment by user won't be done.
    • Minimum/maximum values of row, col : 50% - 150%
    • Values with % can be specified. It's also possible to specify a decimal point, such as 82.5%, up to 2 digits.
  • The item with no settings in font is considered as the condition matches.
    • When there are no settings for both name and size, it's considered as they match in all fonts.
    • Maximum size of font name : Conforms to Office specification. 31 characters.
    • Maximum/minimum size of font size : Conforms to Office specification. 1-409.

Example of programing

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xls-rowcol-controls SYSTEM "xls-rowcol-controls.dtd">
<xls-rowcol-controls>
<xls-rowcol-control>
<xls-key> <font size="10"/> </xls-key>
<xls-key> <font size="8-9" name="MS Gothic"/> </xls-key>
<xls-parameter col="95%" row="82.5%"/>
</xls-rowcol-control>
<xls-rowcol-control>
<xls-parameter col="90%"/>
</xls-rowcol-control>
</xls-rowcol-controls>

Excel function for paper setting

xls-paper-setting function

– Excel function for paper setting by users –

The function to specify the paper settings from outside the program. By specifying the paper size or page orientation for printing, you can get the output differently from the setting of the file.

They are both possible to specify the default value when the paper settings are not saved in the Excel file, and to use the specified value by ignoring the paper setting saved in the Excel file.

The available parameters are paper, paper orientation, top/bottom right/left margins and scaling ratio.

The value first found is adopted in the following order of priority. The setting is independent for every parameter.

Priority order: specified value by user (xlsPaper) > specified value saved in the file > specified default value by user (xlsPaperDefault) > default value embedded in the program

Parameter

Parameters for elements can be specified by comma-delimited character strings. The necessary values belongs to the each element can be specified by putting the colon to separate them.

Parameters are interpreted in order from the beginning. When there is a duplicate element specified, the first specified one will be effective.

Parameter description

  • Paper size : Specifies the paper size.
    • A3, A4, A5, B3, B4, B5, Letter, Legal, custom:SIZEWIDTH:SIZEHEIGHT can be specified.
    • Using custom, you can specify any size for the width and height (SIZEWIDTH,SIZEHEIGHT).
    • Add the unit of mm or inch after the numeric characters. If the unit is omitted, it is considered as mm. It's necessary to specify both width and height. If not, an error will occur.
    • The default is A4.
  • Paper orientation : Specify the paper orientation.
    • Specify landscape or portrait by landscape,portrait.
    • By setting graph:,sheet: in front, the graphsheet and the worksheet can be specified separately.
    • If graph:,sheet: is not added, the setting is effective for both sheets.
    • The default for worksheet is portrait, the default for graphsheet is landscape.
    • When custom is specified as the paper size, this setting is not effective.
  • Scale : Specify the scaling ratio.
    • Specify % or number of pages in tall and wide direction.
    • If you use % specification, add % after the numerical character. e.g. 100%, 50%, 200%
    • If you use the number of pages for tall and wide direction, the entire sheet will be scaled to fit into the specified number of pages.
    • Number of pages can be specified by page:HORIZONTAL:VERTICAL. Specify number of pages in tall and wide direction. If 0 is specified for the one, the other one that is not 0 will be a base for determining the scaling ratio.
    • The default is 100%.
  • Margin : Specify the top/bottom right/left margins of a paper.
    • Using margin, any size of the top/bottom right/left margins (MARGINLEFT,MARGINTOP,MARGINRIGHT,MARGINBOTTOM) can be specified.
    • Add the unit of mm or inch after the numeric characters. If the unit is omitted, it is considered as mm. It's necessary to specify all 4 numeric values. If not, an error will occur.
    • The default is margin:20mm:25mm:20mm:25mm.

Example of programing

-xlspaper A4,graph:landscape,100%

The paper size is A4, graphsheet is in horizontal mode, the scaling ratio is 100%, use the margin specified to the file.

-xlspaperdefault custom:1000mm:1200mm,page:2:1,margin:10mm:10mm:15mm:15mm

The paper size is width 1000mm, height 1200mm, The margin for left/top is 10mm, right/bottom is 15mm, scale the sheets so that the number of pages in wide direction is within 2 and the number of pages in tall direction is within 1 page. This setting use the default value. If the xlspaper option is specified at the same time or the settings are saved in the file, the default will not be adopted.

Restrictions and Limitations

The following are limitations when converting from MS Excel.

  • The conversion result is in print layout format.
  • Portions of 3D View charts cannot be converted.
  • Images set in the header or footer are disregarded.
  • Certain characters of WordArt might not be reproduced.
  • Object shadows, text shadows and 3-D effects are not supported.
  • Row height and column width might not be set correctly.
  • Text box margins might not reproduce correctly.
  • Multimedia objects such as movies and sounds, etc. are disregarded.
  • Gradation and a translucent color might differ from Excel.
  • In MS Office, if the font specified to a character doesn't have corresponding glyph, another suitable font might be substituted. Such substitutions are not done with this product.
  • WMF/EMF contained in documents made by earlier versions of MS Office 95, and saved again in later version of MS Office 97, might not convert.
  • Embedded objects and linked objects of OLE cannot be displayed (If the information for display is embedded in the document, it might display).
  • Office VML shapes may not be convertible. If a shape pasted from the other Office file is VML, it also may not be convetible. (If information for the display is embedded in the document, it might be displayed).
  • Elements specified to Table/Pivot style are disregarded.
  • Elements specified to Conditional Formatting are disregarded.
  • In [Format Cells]-[Number]-[Category], Date and Time formats that begin with an asterisk (*) as the [Type] aren't connected with anything specified for an operating system. These are outputted with the text of the display format preserved in a file.
  • [Format Cells] - [Alignment] - [Text Control] -[Shrink to fit] is not supported.
  • [Format Cells] - [Alignment] - [Horizontal] -[Justify] and [Distributed] are not supported.
  • [Format Cells] - [Alignment] - [Vertical] -[Justify] and [Distributed] are not supported.
  • [Format Cells] - [Alignment] - [Indent] is not supported.
  • [Phonetic] is not supported.
  • [Comment] is not supported.
  • [Hyperlink] is not supported.
  • Cell errors are outputted as is.
  • If there is a long character string of tens of thousands of characters without the linefeed (CRLF), the conversion may fail.
  • [Format Text Effects] and [Format Shape]
    • When you select [Gradient fill] - [Type - Path] in the Format Shape dialog in Office2007/2010/2013/2016/2019(Word,Excel,Powerpoint), the converted result shows the same as when you select [Gradient fill] - [Type - Rectangular].
    • When you specify [Gradient fill] - [Transparency] in Office2007/2010/2013/2016/2019(Word,Excel,Powerpoint), it will be ignored and the converted result shows only as 0%.
    • When you specify [Gradient fill] - [Rotate with shape] in Office2007/2010/2013/2016/2019(Word,Excel,Powerpoint), it will be ignored and the converted result shows the same as when it is unchecked.
    • When you specify [Picture or texture fill] - [Tiling Option] in Office2007/2010/2013/2016/2019(Word,Excel,Powerpoint), all settings of the option will be ignored and converted as [Scale X : 100%] and [Scale Y : 100%]
    • When you specify [Picture or texture fill] and a picture is specified, the shape of the picture will be replaced with a rectangle.
    • The specification of [Slide background fill] will be ignored.
    • [3-D Format] and [3-D Rotation] are not supported. They are converted as if they were not specified.
    • When you specify [Text Box] - [Autofit], the size of the text may not be reproduced correctly.
    • [Picture or texture fill] and [Gradient fill] specified for filling color of text are disregarded.
    • All the specifications for Text Outline are disregarded.
  • The size and attributes of math equations may not convert correctly.
  • The arrangement of shapes and characters, attributes in [SmartArt] may not convert correctly.
  • Shapes and attributes (such as Cap type) added in Office 2007-2019 may not convert accurately.
  • When a figure is specified to be rotated or cropped, the Flip (reversal of right to left or the top to bottom) feature is disregarded.
  • When an image is specified as the background of a figure, even if rotation is specified, the background image will not rotate.
  • Transparency in a figure is disregarded.
  • Stylized text created by Office 2007/2010/2013/2016/2019 WordArt might not be outputted correctly.
  • When an image is pasted on a figure, even if rotation is specified to the figure, the image will not rotate.
  • When [Picture fill] and an image are simultaneously specified as the background of a figure, only the image becomes effective.
  • ActiveX controls cannot be displayed. (If the information for display is embedded in the document, it might display).
  • Images created using [Draw] - [Pen] Gallery added in Office 2019 will be output as substitute images. Line color, line thickness, size, etc. may be different from Office display.
  • Borders and fill colors on a checkbox control are not supported.
  • 3-D effects on a checkbox control are not supported. They are converted as if these are not specified.
  • Sparklines are not supported.
  • Slicers are not supported.
  • The portion that exceeds the rectangle of the figure, such as a balloon, is not outputted across the page. When the rectangle of the figure goes across the page, it is outputted on both pages.
  • Functions added by subscription in Microsoft Office 2016 etc. are currently not supported.

The following are limitations in the conversions from the MS-Excel Charts.

  • New charts (treemap chart, sunburst chart, histogram chart, box-and-whisker plot, waterfall chart and funnel chart) added by Excel 2016 or Office 365 are not supported.
  • Surface chart might not be correctly displayed.
  • Size, position, aspect ratio and angle of the displayed chart (especially 3-D chart) might not be displayed the same as those of the original Excel chart.
  • Data table display is not supported.
  • Axis scale units are not supported.
  • Data labels other than value cannot be displayed. The display of multiple value labels in Bubble charts are also not supported.
  • Data labels legend key display is not supported.
  • Elaborate fill effects, such as Gradient or Texture, are not supported.
  • When an image is pasted and various effects are given, effects will be disregarded and the image will be outputted in the original color scheme.
  • The vertical orientation of the axis label is not supported.
  • Hierarchical item labels might not be correctly displayed.
  • Maximum, minimum and major unit etc. of the axis scale might be different from Excel.
  • In combination charts, the legend item might not be displayed in the correct order.
  • Custom (by specifying the range of cell) error amount is not supported.
  • The position of the data labels might differ from Excel.
  • The last 3 patterns in “border style” are not supported.
  • Superscript and subscript in the axis label fonts are not supported.
  • "Round corners" in the chart area is not supported.
  • Display of the equation in the trendline is not supported.
  • If the chart overlaps with the axis, the chart may be placed on the axis and the axis may disappear.
  • The appearance of an approximated curve may differ from Excel.
  • With the time series axis, the display style may differ from Excel if not specified.
  • Even if the data of an item axis is the date, it does not become a time series axis if you don't explicitly specify it as the time series axis.
  • "Round corners" in the chart area is not supported.
  • Map Charts are not supported.