Changes

Jump to: navigation, search

Excel Importing Guide

401 bytes added, 14:30, 30 September 2022
no edit summary
<languages/>
 
 
<translate>
<!--T:1-->
The instructions below will help you make sure your Excel file is formatted correctly to be imported as a TaticView data sourcedatasource.
<!--T:2-->
'''You can download a sample file here: '''[http[Special://wiki.taticview.com/taticfilesFilePath/Sales.xlsx |Sales.xlsx]]'''
<!--T:3-->
<!--T:8-->
Only one table by spreadsheet can be imported. If the data in two different tables can not be joined, they must be imported as two separated data sourcesdatasources.
<!--T:28-->'''abcCheck the order of the worksheet'''
abc<!--T:29-->If the file (XLS or XLSX) has more than one worksheet (tab), make sure that the worksheet to be imported is the first one in the file. TaticView considers only the first worksheet (tab) of the file, ignoring the others. In the example below, we show how the order of the worksheets should be, so that we can import the '''Sales''' worksheet.
<!--T:30-->
[[File:spreadsheet_order_wrong.png|link=]] [[File:spreadsheet_order_right.png|link=]]
</translate>

Navigation menu