Top "Excel-2007" questions

How to easily create an Excel UDF with VSTO Add-in project

What I am trying to do is to create User Defined Functions (UDFs) for Excel using VSTO’s C# “Excel 2007 …

c# visual-studio-2010 vsto excel-2007

Cannot VBA write data to cells in Excel 2007/2010 within a function

I want to set value for cells by VBA. I have googled, and see some resolution: Sheets("SheetName").Range("A1").…

excel excel-2007 excel-2010 vba

Assign event handlers to controls on user form created dynamically in VBA

I have found many resources on the internet that do almost what i want to do, but not quite.I …

vba excel excel-2007

Use openpyxl to edit a Excel2007 file (.xlsx) without changing its own styles?

I have a .xlsx file to edit, I found openpyxl could manipulate Excel 2007 files. I only want to change the …

python excel-2007 openpyxl

Generate a filtered, dynamic drop down list

I need two dynamic drop down lists for data validation. One containing a unique list of continents to choose from, …

excel dynamic excel-2007 validation named-ranges

Automate Onenote 2010 From Excel 2007, using VBA?

I would like to use VBA in Excel 2007 to step through about 500 receipts, which have been converted to one large …

excel excel-2007 office-interop onenote vba

Always show two decimal points in excel cells using Apache poi

For example, XSSFCellStyle style=(XSSFCellStyle) workbook.createCellStyle(); style.setDataFormat(workbook.createDataFormat().getFormat("#.##")); productCell.setCellValue(12.4); productCell.setCellType(Cell.CELL_TYPE_NUMERIC); …

java excel apache-poi excel-2007

Exit / disable edit mode after double click handled event

I'd like to display a dialog after a user clicks a cell in an Excel sheet. Something like this: Private …

excel excel-2007 vba

Apache POI - How to protect sheet with options?

I'm using the Apache POI to generate an Excel File (2007). What I want is to protect the sheet, but with …

java excel-2007 apache-poi

how to write python array (data = []) to excel?

I am writing a python program to process .hdf files, I would like to output this data to an excel …

python arrays excel-2007 python-2.7 xlwt