BalaReva Excel Activities

Hi Balamurugan! Thanks for upgrading this package to the new Windows framework.  I have one challenge with getting the "Extract Graph Image" to work. Tried multiple times and it only gives an empty jpg file.  Using the exact same settings as I used with the same activity for the Legacy project. Is it a bug?

bala ql penca vali puro pico

With the new update this is not suitable for Windows projectss. Only for Windows legacy. What should we do Bala?

Hello, I have a small question about the SaveAs activity. I have a .xlsm file that I want to take a picture of a specific range and I've managed to do it. But now, I want to exit the Excel file either by saving it as a .xlsm file, basically overwriting the file, or by closing it without saving. If I use the SaveAs activity, I can't find the save as Macro Enabled file, there's a lot of options, but I can't find that one, am I missing something? In the other hand if I use the Close All Excel, it asks me if I want to save it, but then I can't click the "No" option. Any advise?

Thanks in advance.

Hi Bala

I have use your autofit column, but it not working.

Exception from HRESULT: 0x800A03EC

I try to put on delay also not working.

Is the any solution for this issue?

Thanks

Your package is really good, and help me a lot

It worked really well, but I have a question. I am using Copy to File Activity from this package to copy a sheet from one excel to another. The newly created workbook has cells in different color as the one in original sheet. I am not sure if this is a bug at your side or some excel settings in my workstation ?!

Hey Bala,

Thanks much for your awesome work with help the community a lot! Question on the 'Format Cells' activity, specifically in properties panel, Cell Range. I am aware this is InArgument.  If I want to change alignment of a CSV file from cell A1:J100, what and how do I input into Cell Range? I got error message when I input this "A1:J100" (error message:value of string cannot be converted to '1-dimensional array of String').  Thanks much!

hi , 

I try to use BalaReva.Excel.Sheets.InsertImageAtCell Activity.  

The source image is  PNG File (.png), with a size of 100k-150k.

The problem is output Excel file is too large to be transmitted by email. can you teach me how to compress the image in excel by InsertImageAtCell.  

Just like : Click on the Picture Tools Format tab ->In the Adjust group, click on 'Compress Picture' option. 

Thank you.

I just cant find the activitity that change the cell type...

Hello.

We are trying to use the AutoFit Column activity within a loop but it continues to fault and gives the error that the file is already in use. Do you have any additional guidance on how to properly use this activity?

Thanks.

I was referred to you from the forum... I have downloaded your Excel package and wan to use the EasyExcel.HyperLinks.InsertHyperlink.  

I am not sure which process to use to accomplish my task.  I have a hyperlink I scraped from a website but the hyperlink is too long so when it comes in excel it is a text string. 

can you help me.

Hi ,

Does Compataibilty Affects If I am using 2019 + Version of Studio .

--

Mukesh Kala