Forum Discussion
Resident RockstarExcel data changing format upon upload
Looking at your code, I see that your Excel Import includes Kind = Sheet. If you have this in Table format in Excel, then you can change that code to Item = "Table Name", Kind = Table]. If your data is not in table format in excel, then you can turn it into a table by selecting the excel table and pressing CTRL+T. If the info is in this current workbook, then Get data from Table/Range will do this automatically. Honestly, though, I never considered whether or not coulmn names respect date formats or data types.
Wait though, can[t you make these columns type text, and then promote headers? Once you do that, and then promote headers, you cna always go back and change the type.
--Nate
Looking at your code, I see that your Excel Import includes Kind = Sheet. If you have this in Table format in Excel, then you can change that code to Item = "Table Name", Kind = Table]. If your data is not in table format in excel, then you can turn it into a table by selecting the excel table and pressing CTRL+T. If the info is in this current workbook, then Get data from Table/Range will do this automatically. Honestly, though, I never considered whether or not coulmn names respect date formats or data types.
Wait though, can[t you make these columns type text, and then promote headers? Once you do that, and then promote headers, you cna always go back and change the type.
--Nate
Resident RockstarI tried making them text no the excel file didnt work, set them as text column on the BI same it failed when promted the header xD,