Changes

Jump to: navigation, search

Excel Importing Guide/en

331 bytes added, 02:28, 5 October 2022
Updating to match new version of source page
As instruções abaixo irão ajudá-lo a formatar corretamente seus arquivos Excel para importação no TaticView.<languages/>
'''É possível baixar um arquivo de exemplo formatado corretamente em: [http://wikiThe instructions below will help you make sure your Excel file is formatted correctly to be imported as a TaticView datasource.taticview.com/taticfiles/Sales.xlsx Sales.xlsx]'''
'''Se após seguir o guia, ainda ocorrerem problemas de importação, verifique [[Importing Problems/pt-br|Problemas de Importação]].'''
'''You can download a sample file here: '''[[Special:FilePath/Sales.xlsx|Sales.xlsx]]'''
'''CabeçalhosIf you still have problems importing, try [[Importing Problems]].'''
Cabeçalhos não são obrigatórios'''Headers''' Headers are not mandatory, mas se estiverem presente devem estar em uma única linha but if present they should be contained in just one row (a primeirathe first one) e não estarem em células mescladasand not be in merged cells.
'''Evite Múltiplas TabelasAvoid Multiple Data Tables'''
Apenas uma tabela por planilha pode ser importadaOnly one table by spreadsheet can be imported. Se os dados de diferentes tabelas não podem ser consolidadosIf the data in two different tables can not be joined, então elas devem ser importadas como diferentes fontes de dadosthey must be imported as two separated datasources.
'''CorrijaFix/Remova LinhasRemove Empty Rows/Colunas VaziasColumns'''
Remove or Fix (by adding at least a header) to full empty rows and columns.
'''Remove All Table External Items'''
Files should only contain the data table to be imported. All non -related data, as main headers, images, charts, must be removed prior to importing.
[[File:normalization_wrong.png|link=]] [[File:normalization_right.png|link=]]
 
 
'''Check the order of the worksheet'''
 
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.
 
[[File:spreadsheet_order_wrong.png|link=]] [[File:spreadsheet_order_right.png|link=]]
FuzzyBot
11,856
edits
Retrieved from "http://wikidev.taticview.com/index.php/Special:MobileDiff/5694...29864"

Navigation menu