How to replace all data in Excel?

[Jaysha_18]

Hi,

How I can replace all contents in excel spreadsheet.

Suppose if I have  3x3 table and deleted one row from it in Labview.

Now I want to replace previous table with new data in same sheet.

Check below image for reference.

What is best way to do it?

[Norbert_B]

First of all, if ALL data is being REPLACED, it is simpler to create a NEW sheet...

Your screenshot shows that you "only" want to drop specific rows, keeping everything else as it is.

You have to take a look into the ActiveX or .NET API from Excel. For creating new sheets, the Office Report Toolkit could help you.

Norbert

[LV_user1 · Accepted solution]

If you want to replace all data it is as good as overwriting the existing data with new data.

Simplest way will be if you are using the csv file then you can directly overwrite the existing file by using write to spreadsheet file function and making its overwrite parameter true.