White space in cell in excel - with CLAUDIE_xlsx addon

[resheffink]

Hi everyone.

I tried using CLAUDIE_xlsx addon on LabVIEW in order to write and read data from an excel file.

I succeeded with creating, opening and writing to an excel file.

But when after I write text to spreadsheet in excel, I see that in addition to the text in the excel file, there is a blank cells without the excel cells boarders.

This is the blank cells in the excel file:

And here is the LabVIEW connections:

Do you know how I can fix this?

Also, is it possible to read a specific cell from a spreadsheet in excel or only a specific row? if it's possible, how do I do it?

Thanks,

Reshef

[GerdW · Accepted solution]

Hi Reshef,

But when after I write text to spreadsheet in excel, I see that in addition to the text in the excel file, there is a blank cells without the excel cells boarders.

You seem to write a lot of empty strings to your sheet - as far as can be seen from your blurry image…

is it possible to read a specific cell from a spreadsheet in excel or only a specific row?

Yes and yes.

if it's possible, how do I do it?

Usually you can do this using ActiveX calls to remotely control Excel.

I don't know how your CLAUDIE toolkit handles those calls - have you read its manual or tried to contact the support?

[resheffink]

I've found the problem. it needed a const length of array to be inserted into excel. now everything works fine.

Thank you for your help!

[sdhafer]

Hello,

So im trying to read an excel file with labview in order to display some data on led screens. 

When i tried a simple VI, as a first step, to read an excel file it returns an error code 10 : duplicate path. 

I used Claudie_xlsx addons which doesnt require activeX.

I have searched in google for some samples but i guess people are not familiar with Claudie addons.

I have attached the some screenshots. 

Thanks,

Dhafer 

---

---

 

[maxnoder1995]

I have an existing excel with 2 blank sheets. When I write to sheet number 2, the style of sheet number 1 disappears. Does anyone have experience with the addon and can help with an example of writing to Excel correctly?