phermi
asked on
How to aling images in Excel cells
Hi all,
We have a web app that uses ASPOSE.CELLS to generate an Excel version of the HTML report in order to (a) export the report to Excel and (b) produce a PDF of it.
There is a column that shows an image as a visual indicator of the results. Such images can be from 15x15 up to 65x65 pixels.
We need to align the images inside of the cells and no matter what we do, we do not seen to get it.
Can anyone help us?
Attached is a little sample of the case. The images are already set to "move and size with cells" and are not "locked".
1.xls
We have a web app that uses ASPOSE.CELLS to generate an Excel version of the HTML report in order to (a) export the report to Excel and (b) produce a PDF of it.
There is a column that shows an image as a visual indicator of the results. Such images can be from 15x15 up to 65x65 pixels.
We need to align the images inside of the cells and no matter what we do, we do not seen to get it.
Can anyone help us?
Attached is a little sample of the case. The images are already set to "move and size with cells" and are not "locked".
1.xls
The attached file contains all indicators well contained within the cells. What else do you want to do?
ASKER
ALIGN THEM .... that is the topci of the post.
I need to align then horizontally and vertically in the cell as they can have different sizes !!!
I need to align then horizontally and vertically in the cell as they can have different sizes !!!
Left, centre or right?
Top, bottom or middle?
Top, bottom or middle?
ASKER
the image must be aligned TOP (vertically) and CENTERED (horizontally).
Please have in mind this is to be done programatically, not interactively using Excel.
Please have in mind this is to be done programatically, not interactively using Excel.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ssaqibh: Thank you very much.
We are now looking at ways to execute that somehow. ASPOSE does nto seem to allow us to execute macros during the generation of the Excel file.
In any case, thanks.
We are now looking at ways to execute that somehow. ASPOSE does nto seem to allow us to execute macros during the generation of the Excel file.
In any case, thanks.
So does that complete this question?
ASKER
Yes sir. Thanks a lot
You could drop this into the worksheet under the vba before save hook if you can write to that during file generation.
ASKER
ScriptAddict: Thanks. We are not sure how to do so. It will be very helpfull if you can detail it for us.