How can I delete excel cells without shifting (in direction) the other cells

[arnaud2404]

I am trying to delete the contents of cells in an Excel file with CVI. Cells contents are effectively deleted but the other cells are shifting in direction (up or left). I don't want to shift the others cells. How can I do?
Thanks for answer

[Sissa]

Hello,

The Delete function in ExcelReport.fp delete the cells and shift the other cells in the direction you chooses.
To clear the contents of the cells, the best is to use Excel_RangeClearContents function in Excel2000.fp library.
If you are familiar with VBA you will find the same function.
1) Select your range (one or multiple cells)
2) Call ClearContents

Hope this helps

Salissou ISSA
NI France