rounding numbers to the nearest integer in Excel

[Oesen]

Hi GerdW

I have done that in message 6, and it still rounds the numbers.

[GerdW]

Hi Osman,

in message 6 you included a text in the message and in message 10 you wrote something about opening and saving a file (I presume in Excel)...

Please attach the text file as it is created from your VI...

[Oesen]

Im a bit confused, but let me explain it in this way.

Now i open a new notepad document, and save it as example.txt in the desktop

I change the filepath to example.txt

I test my VI and get the results below:

[GerdW · Accepted solution]

Hi Osman,

please try the attached VI.

I replaced WriteToSpreadsheetFile with ArrayToSpreadsheetString and WriteText.

[Oesen]

Thanks for the help GerdW..

I works now !!!

So i always need to use array to spreadsheet, when i will have some data from a array to excel ?

[GerdW]

Hi Osman,

WriteToSpreadsheetFile should do the same as my example.

But maybe you accidently changed something in that VI?

[Oesen]

Hmmm.. i can see that it doesn't include my headers in the excel file now

[GerdW]

Hi Oesen,

ok, I forgot to set the file position after opening the file for saving your data.

Either include a SetFilePosition after OpenFile or write the header data after OpenFile using the same appraoch like me!

[Oesen]

Something like this ?

[crossrulz]

---

@Oesen wrote:

Something like this ?

---

Change that start enum to end and you will be fine.