delete all cell in a collumn in an excel with ilogic

[Darkforce_the_ilogic_guy]

is that a to dele all not emtry cell under collum A and B  start form cell A3 And B3  with ilogic?

I am using it as a log fil... but want to cleal the file if I start my ilogic on a new file

[JelteDeJong · Accepted solution]

i have none code to test with but probaly you could do something like:

xlSheet.Range("A3:A9999").Delete

[WCrihfield]

Using iLogic, I'm not seeing any easy way to actually 'delete' a cell in an Excel file. Nor be able to set which option to use for either shifting the other cells, Entire Row, or Entire Column, after you delete it, as you have within Excel.

I see a method to 'Clear' its value, though, if that's all you need.

You would most likely have to do this using Inventors API and VBA code with the VBA Editor, once you've included the right "References" for working with Microsoft Excel.

[J-Camper]

replied to wrong post

[J-Camper · Accepted solution]

I think this code should work:

Dim FilePath As String = "C:\Projects\testing.xlsx"
Dim SheetName As String = "This_Sheet"
Dim Column As String = "B"
Dim Row As Integer = 3

GoExcel.Open(FilePath, SheetName)

While Row < 99
GoExcel.CellValue(Column & Row) = "" 'Value
Row = Row+1
End While

GoExcel.Save

GoExcel.Close

Should be easy enough for you to change the string values to look for the correct workbook.

[J-Camper · Accepted solution]

I think this code should work:

Dim FilePath As String = "C:\Projects\testing.xlsx"
Dim SheetName As String = "This_Sheet"
Dim Column As String = "B"
Dim Row As Integer = 3

GoExcel.Open(FilePath, SheetName)

While Row < 99
GoExcel.CellValue(Column & Row) = "" 'Value
Row = Row+1
End While

GoExcel.Save

GoExcel.Close

Should be easy enough for you to change the string values to look for the correct workbook.