反馈已提交
网络繁忙
6.0
/
6.0.8
1. If an Excel file contains multiple sheets, the uploaded file name will be the sheet name.
2. Upload through dragging an Excel file to FineBI is allowed.
This document describes how to add an Excel file to Public Data.
FineBI supports uploading batch Excel files.
You can upload CSV, XLS, and XLSX files.
1. You can upload Excel files of which versions are Excel 2003 and Excel 2007 with the xls and xlsx suffixes. However, you cannot upload Excel files saved as Excel 5.0/95 with the xls suffix.
2. Encrypted Excel files cannot be uploaded.
You need to choose System Management > Security Management > Security and disable File Upload Verification before uploading a CSV file.
Before uploading the file, you need to confirm that the first row of the Excel table has no merged cell, otherwise, the upload will fail.
Besides, you need to confirm that no content calculated through functions such as VLOOKUP and SUMIFS is included in the Excel dataset.
You can download the Example.rar.
Go to Public Data and select a folder on which you have management permissions. Choose Add Dataset > Excel Dataset, as shown in the following figure.
Select the Excel files you want to upload. You can box-select multiple files with Ctrl or Shift.
3. The sheets will be expanded automatically. Select the needed Excel tables and click OK.
The name of the table is that of the sheet by default. You can modify the name manually.
If there are tables with the same field name, field type, and field order in the selected tables, a prompt "The fields in the data table are consistent, whether they are merged into one table?" will be displayed.
· If you click Do not merge, the three tables will be uploaded normally.
· If you click Merge, the Shanghai and Beijing tables that contain the same fields will be merged into one table.
The data volume in an Excel file cannot exceed 100,000. You can continue uploading when uploading an over-limit file.
Identification Rules in Extracted Data Version
First, it identifies whether the added field is in numeric format (numbers starting with 0 are not recognized as numbers.).
Second, it identifies whether the added field is in date format.
Third, it identifies whether the added field is in text format (values longer than 15 characters default to text format.).
If the field types of the table after the table is added differ from those before the table is added, you can modify the field types manually. If there is a field value with a decimal type (such as double, float, etc.) in the added Excel dataset, decimal places may not be accurately displayed when you use a group table or cross table for summary calculation.
Identification Rules in Directly Connected Version
After the null value is removed, the first 100 rows are selected for field type prediction: If there are three field types in the first 100 rows, the field type whose number of rows exceeds 33 is the identification type. If there are two field types in the first 100 rows, the field type whose number of rows exceeds 50 is the identification type. If there are more than one field types that have the maximum number, the identification type will be determined in order of text, data, value, and null.
feedback
鼠标选中内容,快速反馈问题
鼠标选中存在疑惑的内容,即可快速反馈问题,我们将会跟进处理。
不再提示
10s后关闭