Hi @ChanduMohammad S
I used Excel Basic package since i didnt have Office installed. So i guess by this way i can play with excel.
Also i found my issue I wasnt so familiar with ExcelBasic package, I have to close the Excel file to see if it is filled or not.
When i open excel file, i see its not filled if i dont close it.
I see this diffference between having Office installed and using Excel:Advanced package, and having no Office and using Excel:Basic package
Now i see the excel file is filled with right values after closing and opening the file
Hi @Ashwin A.K
Thank you for the reply
Its the correct column and row thats being set to, actually.
Also something i figured out, for example i set A2 with a value of 5210
when i open excel file i dont see thats written, but when i use ExcelBasic: get single cell of A2, it gives me correct value in a message box
Hi @Semih Öztürk ,
Can you please add the message box and check before setting the value in excel whether the variable has the data or is empty?
Thanks!
Great @Semih Öztürk , FYI Using Close Command in Excel Basic will Save changes when closing file. Additionally you can also use Excel basic: Save workbook command just like saving the excel sheet.
Hi @Tamil Arasu
Thank you for the reply. I checked it, and there is a value in variable named vTotalWeightStr
I checked the excel session name, its correct too
Hi @Semih Öztürk ,
Curious to know, how you are checking the excel values if you don't have Office Suite installed in your machine?
Hi @Semih Öztürk ,
Could you check what address the value is being set into?
Preferably in a message box
Kind Regards,
Ashwin A.K
Hi @Semih Öztürk ,
There is a chance that you haven't checked the option to save while closing it:
There is also an action for that as well:
Could you try and see if this works out for you?
Kind Regards,
Ashwin A.K
Hi @Semih Öztürk ,
Yes you are right on the Differences pointed out.
Hi @ChanduMohammad S
Yeah, i thought i could see the change before i close the excel file or save the file like how its in Office installed on the machine, but there is a difference. Even if i open excel with excel basic package, i dont see its opened, it works on background i guess. But installed excel was different.
Hi @Ashwin A.K
Yeah thank you, i just tried to look at the excel before saving it closing the file just like how it was using with installed excel
so if i use excel basic package, i have to close the file or save the file to see the changes.