Excel write to first free row on column help

[MikeC (Mike)]

Hi Guys,

Thought this would be easy

Ive attached some pics to help.
In the message box I have output the first data row plus first free row, 1 and 6.
Im looking to write cell to first free row, which is row 6.
Attached the error.

[Rahul_Unnikrishnan]

Hello,

Could you please try (First_Free_Row-1)… Because the row index will start from ‘0’. So total number of row which is filled is “0-4” and the index of first free row will be “5”. Can you plz try this.

[MikeC (Mike)]

Hi,

In " Find first/last data row" , I have already configured it for first free row.
In the msg box it states the first free row as 6.
Ive tried to do as you suggested but unsure where to place the -1.

No offence but surely the whole point of first free row is to not have to input -1 ?
Thanks buddy

Excel.Sheet(“Sheet1”).Cell(First_Free_Row.ToString)

[Rahul_Unnikrishnan]

Hello,

Here in the Expression Excel.Sheet(“Sheet1”).Cell((First_Free_Row-1).ToString)

In the message box, value “6” means its the Row Number, but the index will be “5” as per my understanding.

[MikeC (Mike)]

Nope, thanks anyway buddy…

[Rahul_Unnikrishnan]

Hello,

If possible could you share the workflow and the Excel which you are trying.

[MikeC (Mike)]

Hi,

Ive attached the xaml, the excel is is as per pic, column A with 1,2,3,4,5.
I couldnt get this to work in my main automation so I created this simple flow hoping to find out what should be a very easy task lol.

Main.xaml (11.6 KB)

[Rahul_Unnikrishnan]

Hello @MikeC ,

Please use the below formula. It will work. You can also refer the attached project.
If your issue is resolve plz mark it as solution.

Excel.Sheet(“Sheet1”).Cell(“A”+(First_Free_Row+1).ToString)
Test.zip (8.5 KB)

[MikeC (Mike)]

It works ! thanks very much buddy.

My original which gave the error.
Excel.Sheet(“Sheet1”).Cell(First_Free_Row.ToString)

Your suggestion was inserting a blank row, as in it wrote to rows 6,8,10 etc.
Excel.Sheet(“Sheet1”).Cell(“A”+(First_Free_Row+1).ToString)

Ive altered your suggestion by removing the +1, this works perfectly, ran it 3 times.
Excel.Sheet(“Sheet1”).Cell(“A”+(First_Free_Row).ToString)

Thanks very much again but I find this absolutely rediculous, the whole point of StudioX is to negate string manipulation surely ?
Unless were both missing something ?

Thanks again buddy

[Rahul_Unnikrishnan]

Glad to here that

[MikeC (Mike)]

Hey buddy,

In the write cell action im not seeing how to choose column ?
Lets say I got first free row on column A which is row 6.
In write cell, how to specify column B ?
Something like Column B & row = first free row which is B6.

Thank you.

[Rahul_Unnikrishnan]

Just try like B+Fist_Free_Row.ToString

[MikeC (Mike)]

Sorry just figured it out lol, I stupidly deleted one of the quotes

Thanks again