Inserting data in excel from user specified cell

[temin_fpga]

Hi Felipevv

        Thanks for the reply. I worked on it and got a solution, few interlocks was giving me a headache that are finally fixed.

Please find the attached code.

[danil33]

Hi temin,

                You have to mark Felipew's post as the accepted solution and not yours.

                Thank you.

[Ken_Naylor]

I fing the best way is to create a range with the first cell and then resize that range with the Range.Resize method with the input as the size of the array you want to write.  See attached vi.  Btw the attached vi also reads from a spreadsheet given the start cell and size of the array.

Ken

[temin_fpga]

Hi Ken

          Thanks for the reply. Can you post the two sub VIs that this VI uses. This code looks beautiful.

[Ken_Naylor]

Sorry forgot about the 'housekeeping' vis see attached

Code-Decode Cell reference converts Row-column to 'A1' cell notation and vice versa

Convert to variant converts the string array to a variant as strings or as double (specific to a particular solution not general so you could insert your own vi here The writing to the range required a variant datatype.)

enjoy

Ken

[Felipevv]

Can you upload the VI for Labview 2009?

I would like to see a more efficient code.

Thanks.

[Ken_Naylor]

For LabVIEW 9.0 as requested

Ken

[temin_fpga]

Hi Ken

Thanks for your reply.

In your logic if Cell Reference is something like AA, it will not work. The logic will hold good if the cell reference column is from A-Z.

In this case I feel my code is more generic since it will work even if start of cell is AA or AAA.

Thanks for the code.

Regards

Temin

[Ken_Naylor]

I disagree - Which bit of the code does not work with cell references begining AA.  I have tested Code-Decode Cell Reference.vi up to the limit of my Excel (2003) and it works fine.  See screen capture

Ken

[temin_fpga]

Hi Ken

     please check below the screenshots of your code.

Regards

Temin