Tag Archives: image

Extract Images from an Excel Document

Questions: I am doing some data mapping from an .xls excel document, and I am trying to write a quick script to pull images out excel document. What is the quickest, simplest way to do this programatically? I am running Ubuntu 10.10 and I would prefer to user python if possible. Answers: a XLSX file… Read More »

Insert Image on Excel using Open XML

Questions: I am using this toolkit to write Excel.Every thing is fine with this, but i am not getting how can i inset image and put style on some rows on my excel i am using c# Answers: I am using EPPlus for this specific task. It’s a really nice and stable library. EPPLus –… Read More »

Adding images and text to an old Excel game [closed]

Questions: I wanted to update an old VBA Excel application with new images. The application can be found at https://sourceforge.net/projects/shag/. I figured out how to update the images: by tediously selecting each of the 64 images and selecting ‘change picture’ in the Game sheet. But when I change the name in the Data sheet and… Read More »

How to import a sheet with images?

Questions: Workbooks.Open fileName:=ThisWorkbook.path & “\Sea.xlsx” Workbooks(“Sea.xlsx”).Sheets.Copy before:=ThisWorkbook.Sheets(“Sky”) Workbooks(“Sea.xlsx”).Close False This works but on Sea.xlsx there was a sheet with images. Sheet is copied, but the images are not. Instead, I have boxes with text: This image cannot be currently displayed. Answers: I met this problem too and I think I’ve found a solution for it.… Read More »

Set Image as Header in Excel using Apache poi

Questions: I’ve the code below to set Header for Excel using Apache-Poi HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet worksheet = workbook.createSheet(“POI Worksheet”); Header header = worksheet.getHeader(); header.setCenter(“Header”); Is that possible to set an Image(.jpg format) instead of String as a Header using Apache Poi, ie, Header header = worksheet.getHeader(); header.setCenter(image.jpg); // This is pseudo code… Read More »

Excel VBA – Fetch Blog Post Text without Loading Images

Questions: I am trying to fetch blog post (text only) using the below code: Function extractPostBody(myURL As String) As String Dim IE As New InternetExplorer IE.Visible = True IE.navigate myURL On Error GoTo 0 Do DoEvents Loop Until IE.readyState = READYSTATE_COMPLETE Dim Doc As HTMLDocument Set Doc = IE.Document For i = 0 To Doc.getElementsByTagName(“p”).Length… Read More »