I'm exporting an UltraWebGrid to Excel using the Excel Exporter. It works great, but now my customer would like to insert the company logo onto the spreadsheet. Is there any way to do this? I've been looking through the docs and forums and haven't seen anything.
Thanks!Scott
Here is one way you can do this:
I create a workbook then a worksheet. I then load an image then set some positioning properties. You can also use the setBoundsInTwips method as well. I add the image to my worksheet and then export my grid to that worksheet starting at the 10th row.
That looks perfect. At the moment I'm using an older version (2006 v1) that doesn't seem to have the WorksheetImage class, but we are planning to upgrade soon to the latest version.
Thanks for your help!
Well, it looks as though I need to stick with 2006 v1 for this project...is there any other way to get an image into my Excel file with this version of the exporter?
devip said: Have you got the answer? Please share with us if you have. I user 2006 V3 and has to export the images to excel. Please let me knwo if it is possible.
Have you got the answer? Please share with us if you have.
I user 2006 V3 and has to export the images to excel. Please let me knwo if it is possible.
Unfortunately, we did not find a solution within the time constraints of the project. Instead, we used Crystal to generate a PDF with the exact formatting the client wanted. In this case, they decided they could do without being able to manipulate the data in Excel.