Im having difficulty with using Apache POI API. Im trying to import an excel them only select certain rows and cells to extract from the import. Im currently able to import, but i cant extract certain cell. Here is code:…
I tried using RichTextString to get individual character's font, but it works fine only for a cell with at least one different style is applied. In the case of the same style applied throughout the cell: font1 = workbook.getFontAt(richString.getFontAtIndex(i)) here,…
I use this code to change the font in excel to color, which I define Color sColor = new Color (value,0,0); XSSFColor userColor = new XSSFColor(sColor); CellStyle style = wb.createCellStyle(); XSSFFont font = wb.createFont(); font.setColor(userColor); style.setFont(font); cell.setCellStyle(style); Can I change…
Context: Trying to open XLSX file using Apache POI's poi & poi-ooxml 4.0.0 version jar's Issue: The program throws an error as shown below. I find this error when I use version 4.0.0, as I was able to open excel…
I'm trying a VBScript that should open Excel, open a workbook, run a macro and then close everything. Dim objExcel, xlBook Set objExcel = CreateObject("Excel.Application") Set xlBook = objExcel.Workbooks.Open ("path to the xlsm file") objExcel.Visible = True objExcel.Run xlBook.name &…
I have an inventory list which has contains 1000 product with zero pictures, and a sheet which have 300 links of the product pictures in excel, I'm looking for a way to combine the two sheets, so that each product…
We have a data warehouse on RJ Metrics (Magento BI Tool) that we are trying to clean up using Excel by building a data dictionary, I've created a sheet with instructions and formulas that takes the jumbled data we copy…
I've put together a table to track the success of some SEO efforts. For each row I'd like to compare the starting value with the most recent value. We update this table each week, so it'd be great if it…
I'm having a problem mass concatenating two columns of data, and not sure how to go about it. I am not that proficient with excel, so anyone who could lend any actionable insights that would be great. Basically I have…
We're making a quiz game. We have a question bank on a Google Drive Spreadsheet. We have a designer who has made a generic design for the question cards, in Photoshop. Now, can we somehow transfer the questions, with the…