Features and settings that are not fully supported during conversion

Some settings and formatting in Excel workbooks are not supported by InfoPath. When you convert a workbook that contains such settings, the resulting InfoPath form template will not contain those features or settings. For example, if your workbook has a header that contains an image, the image will not be preserved in the resulting InfoPath form template because InfoPath does not support images in headers and footers.

The following is a list of features and settings that are not preserved when you convert an Excel workbook to an InfoPath form template:

The following list explains the features and settings that are partially supported when you convert an Excel workbook to an InfoPath form template:

Cells with data formatting Styles or colors applied to cells with data formatting are not converted. For example, if a cell is formatted to display negative numbers as red text, the number value is converted, but the red text formatting is not.

Hyperlinks that reference unsupported protocols All hyperlinks are converted, but if the hyperlink uses a protocol other than http:, https:, ftp:, or mailto:, the hyperlink will not work when a user clicks the link.

Header and footer alignment and formatting A header or footer in an Excel workbook can contain a left, middle, and right section. These are concatenated upon import to InfoPath. For example, a workbook with a left header containing the name 'Wendy Wheeler,' a middle header containing the title 'Status Report' and a right header containing date 'October 13, 2007' would be converted to an InfoPath form template containing a single header with the following text: 'Wendy WheelerStatus ReportOctober 13, 2007.' If only one section in the workbook's header or footer contains text, the resulting text in the form template will be aligned accordingly. For example, if only the right section of the header contains text in the workbook, then the corresponding text in the form template will be right aligned. Otherwise, all header or footer text is aligned left when it is imported. The font setting applied to the first header or footer section in the workbook is applied to the entire header or footer in the resulting InfoPath form template.

Font conversion Although InfoPath imports the fonts from a workbook when creating a new form template, if the fonts in the workbook are not available on the computer where you perform the import, alternate fonts will automatically be selected for the form template.

Implicitly merged cells In Excel, if you type more text than will fit in the current cell, the text will appear on top of the subsequent cells as if the cells had been merged. InfoPath does not support this feature. If a converted cell contains more text than the cell width can accommodate, the text will wrap to the next line in InfoPath. To prevent this, before you import your workbook, select the cell and as many subsequent cells as are necessary to contain the text, and merge the cells so that the text fits within the merged cell.

PivotTable reports PivotTable reports are converted as layout tables.

Very large tables InfoPath supports tables that are up to 63 columns wide and 999 rows long. If an Excel workbook exceeds these limits, only the first 63 columns and 999 rows will be converted.

Note: Some Excel workbooks cannot be opened without a password. If this is the case with your workbook, you may not be able to successfully import it into InfoPath. To fix the problem, try removing the password requirement for the workbook before you import it. In addition, some workbooks are designed to prevent users from moving, deleting, hiding, or changing the name of worksheets, and from changing other structural elements in the workbook. If this is the case with your worksheet, you may not be able to successfully import it into InfoPath. To fix this problem, try removing the structural editing restrictions for your workbook before you import it.

Convert an Excel workbook to an InfoPath form template

Convert Infopath Form To Pdf C#

  1. On the File menu, click Import Form.
  2. In the Import Wizard dialog box, click InfoPath importer for Excel workbooks, and then click Next.
  3. Click Browse.
  4. Locate and click the Excel workbook that you want to convert, and then click Open.
  5. To change the default import behavior, click Options, and then select the options that you want.
  6. Click Finish.
    Note: Depending on the layout and complexity of your Excel workbook, some layout elements or controls might not appear as you expected in the resulting InfoPath form template. As a result, you may need to make adjustments to your new form template after you convert it.