Export in Excel

In this article

Export selection only
When activating this option, the program exports only the selected area.

File Name
In this area it is necessary to insert the name of the new file that the program will create to export the data. If, however, an existing file is selected by using the Browse button, the program will overwrite it with the new data.

Display file immediately
As soon as the MS Excel file has been created, the software to view it will be launched. In this way, the result of the export can be seen immediately.

Options

Create cell names
This option will automatically give a name to each cell as the file is exported. For example, the cell that contains the balance for account 1000 will receive the name: "Accounts_1000_Balance" in Excel. This means the user can univocally identify each cell independently from its position on the sheet and thus create Excel reports that don't have to be corrected if the account plan is changed. The user thus saves having to manually carry forward any accounting data to Excel. However, inserting the names of the cells does slow down the opening of the Excel file.

Create table names
With this option, the program will automatically give a name to the whole area of the cells belonging to a table, at the moment the file is exported. For example, the area formed by the cells belonging to the Accounts table will be identified by the name DB_Accounts. This option is necessary if, when creating reports in Excel, database functions are used.

Use names Xml (English)
The cell names can either be defined in their original accounting language, or with their English name. In the original language, the names will be understandable to someone who speaks that language, but they will not be universally understood like a name in English would be. By selecting this option the user would have, for example, "Accounts_1000_Balance" instead of "Conti_1000_Saldo".

Protect tables
The entire content of cells is locked when selecting this option so that it is only possible to edit the format. This prevents the possibility of making any unintentional changes to the exported data. The user can remove this protection at any time by using the appropriate command in Excel.

Export selection only
If this cell if activated, only the selected area is exported.

Other Tabs

For the explanations of the other tabs, please visit the following pages:


Export result

Each accounting table is displayed in a different sheet in the Excel file

Use the cell names instead of the row/column references:

  • The names return the desired value even when a new row or column is being entered.
  • The names are easy to use and understand
    "Accounts_1000_Balance" refers to the balance of the 1000 account
    "Accounts_1000_Description" returns the value of the cell that contains the description of the 1000 account
  • The names can be used in the formulas
    "=Accounts_1000_Balance" returns the value of the cell that contains the balance of the 1000 account
    "=Accounts_1000_Balance/1000" divides the balance of the 1000 account by 1000
  • By using the names, it is possible to create links to various files.

A link to a cell is being composed of:

  • File name
  • Table name
  • Cell name

 

help_id
TabConvertToExcelBase

This documentation is outdated

The most complete and up-to-date documentation is the one of Banana Accounting Plus: Try it now

Share this article: Twitter | Facebook | LinkedIn | Email