Smartstaff, administrator
3,732
edits
Changes
→Naming Cells
===Naming Cells===
Platform3 will need to know which cells you want to parse so we need to name those cells so we can refer to them later. We will do this by naming cells in Excel. You can name individual cells and groups of cells. In this example we are going to name individual cells only and use those to create activities.
# Give a name like '''Salaries''' to the header cell you want to parse into Platform3. I will use that named cell to populate a specific custom field value later.
# You can define the cell name in Excel by clicking on the desired cell, go to the '''Formulas''' tab and click '''Define Name'''. Once a name has been defined for a cell you can see it in the '''Name Box''' when the desired cell is selected. [[File:Excel-parser-2020-spreadsheet-namebox.png|thumb|none|500px|Defining a name for a cell, so we can refer to it later. The defined name shows up in the name box when a cell or group of cells is selected.]]
# Give a name like '''StartingSalaries''' to the first cell you want to parse into Platform3. I could give names to all the cells in this row but instead I chose to name the first cell and then I will refer to the other cells in the row using the syntax '''"col_1"''', '''"col_2"''', etc.
# You may wish to name other cells, for example I also named '''SalariesHeader''' and '''SalariesSubTotal''' so I could map to those as well.
