For anyone who finds that their Excel-report puts everything into one column, use " " between every value where you would naturally need a new column to start. Without the citation marks of course. (This comment would have saved me 2h)
For me the comma did not work also. Excel put all the data in one cloumn. So I did a quick research: CSV file is incorrectly displayed in Excel: Symptoms: You are trying to open a .csv file in Excel and all of the data is displayed in the first column. Cause: The root of the problem is different separators set in your Windows regional and language settings and the csv file. In North America and some other countries, the default List Separator is a comma. While in European countries the comma (,) is reserved as the Decimal Symbol and the List Separator is set to semicolon (;). When I tried with the semicolon it finally worked. :)
Thank you so much… it is very useful and you makes it simple for understanding
This is a great video. Thank you
TQQQQQ SO MUCH FOR MAKING VIDEOS ON TEMPLATE/REPORT EDITING
Thank you for providing the valuable information.
For anyone who finds that their Excel-report puts everything into one column, use "
" between every value where you would naturally need a new column to start. Without the citation marks of course. (This comment would have saved me 2h)
Great job sir thanks alot
Thanks 😊
GRATE IMFORMATION. THANKS I LEARNT CREATE REPORT
For me the comma did not work also. Excel put all the data in one cloumn. So I did a quick research:
CSV file is incorrectly displayed in Excel:
Symptoms: You are trying to open a .csv file in Excel and all of the data is displayed in the first column.
Cause: The root of the problem is different separators set in your Windows regional and language settings and the csv file. In North America and some other countries, the default List Separator is a comma. While in European countries the comma (,) is reserved as the Decimal Symbol and the List Separator is set to semicolon (;).
When I tried with the semicolon it finally worked. :)
thank you. you saved me
thank you sir
Fir me the guid nber not hughtled in the model
is it possible to convert excel file to tekla .rpt file