column added automatically in excel file

Question

Nidhal Bouzouita 2021-12-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1602365-column-added-automatically-in-excel-file

评论： Nidhal Bouzouita 2021-12-3

采纳的回答： Peter Bonavita

Hello dear community,

i am trying to write those data in the excel sheet :

all the values with 6 digits (with yellow) became different : the comma shifted to the right (like 320,425 for the first yellow one), it looks like the way of writing into the excel shifted it automatically because i debugged it and i found the value before writing into the excel file are correct , any confirmation please ? if so any suggestions ?

I attached the needed files

2 个评论
显示无隐藏无

Image Analyst 2021-12-3

Make it easy for people to help you. Please attach your variable in a .mat file, and give your code for writing to the workbook.

TUTORIAL: How to ask a question (on Answers) and get a fast answer

Nidhal Bouzouita 2021-12-3

i attached here the .mat, the script and the excel output file

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Peter Bonavita 2021-12-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1602365-column-added-automatically-in-excel-file#answer_846990

在 MATLAB Online 中打开

Hi Nidhal,

Are the commas (,) in your data intended to represent decimal places? It seems the entry "35,5555" is intended to represent 35.5555. MATLAB uses periods to represent decimal places instead of commas. Thus, when calling xlswrite MATLAB interprets "35,5555" as 35555.

In the Excel sheet you provided, the comma shown in cell A2 is from Excel's number formatting. The raw data is shown as 355555 in the equation editor.

If you want the data to appear directly in the text file including the commas, you can use writematrix (introduced in R2019a):

% write the raw text data to a file without xlswrite
writematrix(Val,'text.xlsx')

The result from writematrix is shown below. Note that in this case, the data in Excel is displayed with the "General" format.

If the commas in your data represent decimal points, you can replace them with periods before calling xlswrite, and MATLAB will treat them as decimals:

newVal = replace(Val,",",".");
        TableResult = newVal;
        xlswrite(Fileoutput ,TableColumnName,1,'A1');
        xlswrite(Fileoutput ,TableResult,1,'A2');

I hope this helps.

Peter

2 个评论
显示无隐藏无

Nidhal Bouzouita 2021-12-3

thanks you for your help. actually i can not use newVal = replace(Val,",",".") because sometimes i got for example "12.12" and it is interpreted like "12 Dec" so the excel consider it as date. instead is it possible to use writematrix(Fileoutput ,Val,1,'A2'); ?

actually i am writing a bunch of data i mean i dont have only Val but i have other data to be added , so as you know , the type should be the same for all the data .

Nidhal Bouzouita 2021-12-3