From: Rune Allnor on
On 3 Des, 12:51, "Jos " <jappedane...(a)mathworks.com> wrote:
> > > Anyone with an idea of why this happens?
>
> > Excel files either use a text-based internal storage
> > format with a small number of significant digits
> > (remember, excel was never intended used in engineering)
> > or it exports only a small number of significant digits
> > through the excel API.
>
> > You *can* probably use some voodoo to specify the number
> > of significant digits to be stored or exported, but you
> > will be far better off ditching the excel format as such.
> > Store the data to .csv text files.
>
> > Rune
>
> I tried writing a .csv-file (using the cell2csv.m function found here:http://www.mathworks.com/matlabcentral/fileexchange/4400). But unfortunately, this gives me exactly the same output as when using xlswrite.

Learn low-level file IO. If the canned routines don't
do what you want, you need to be able to do it yourself.

For instance

x = 1;
fprintf('%.12f\n',x)
1.000000000000

will write the number to 12 decimal places. Which, mind
you, needs not mean there are 12 significant digits!

Rune
From: Jos on
Okay, I fully solved my problem :)

Thanks all for helping me!!!
First  |  Prev  | 
Pages: 1 2 3 4
Prev: java and simulink
Next: mincx to gevp