English 中文(简体)
Excel Power 查询:强制将小数点数据导入为文本
原标题:Excel Power Query: Force import decimal data as Text
I am importing data from an excel table into Excel power query. The excel table has decimal data but formatted as Text. When I import this table into Excel Power Query, it reads the decimal data and adds more digits to its end. For instance, the number 1.1 in excel is converted to 1.1000000000000001. Note that not all the numbers are imported in that form. For instance, the number 2.1 is imported as it is. Moreover, when I convert this column type to decimal number in the Power Query editor the numbers appear to be in the correct form. However, I want this column type to be Text not Decimal so I can Merge this query with another query with the correct number form. Please refer to the following screenshots: The data in Excel Table: The data in Power Query Editor: In Power Query when changing the data type to decimal:
问题回答
select that column and try to use text to column function and select Text in the step 3 to transfer the data type to text. Then import to power query to see if the data display correctly or not.




相关问题
import of excel in SQL imports NULL lines

I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

Excel date to Unix timestamp

Does anyone know how to convert an Excel date to a correct Unix timestamp?

C# GemBox Excel Import Error

I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...

Importing from excel "applications" using SSIS

I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...

热门标签