Using Edit in Excel

If Microsoft Excel is installed, worksheets and HTML tables can be edited in Excel and re-imported into Phoenix. Through Excel, formulas can be added to worksheets or formatting changed in HTML tables.

The following topics are discussed in this section:

Editing a worksheet with Microsoft Excel

Editing an HTML table in Microsoft Excel

Note:    if performing a copy/paste of data directly from Phoenix to Excel, review the pasted data carefully as the number of digits or trailing zeros could change since the tools may have different column formats. An alternative method is to send the data to a Table object to create a table with the specified number of decimals/significant figures for each column. Right-click the resulting table and select Copy to Tables folder. In the Tables folder, right-click the copied table and select Edit in Excel, which will open the data in Excel with preserved formatting.


Legal Notice | Contact Certara
© Certara USA, Inc. All rights reserved.