Only for questions on programming against Excel objects or files, or complex formula development.
What VBA code is required to perform an HTTP POST from an Excel spreadsheet?
excel vba http post serverxmlhttpI want to "freeze" Row 1 and Column A simultaneously in Excel 2010. Is this possible?
excel excel-2010I'm trying to draw down the formula that's in cell M3 to the end of the data set. I'm using …
excel vba formulaIn this section of code, Excel ALWAYS prompts: "File already exists, do you want to overwrite?" Application.DisplayAlerts = False Set …
excel vba excel-2010I'm doing some benchmarking, and I want to use Excel to produce graphs of the results. I've got a simple …
excelI'm running excel 2007 on XP. Is there a way to stop a macro from running during its execution other than …
vba excel terminateI have excel file with such contents: A1: SomeString A2: 2 All fields are set to String format. When I read …
java excel apache-poiHow could I convert an XLS file to a CSV file on the windows command line. The machine has Microsoft …
windows excel csvI have a column containing RGB values, e.g.: 127,187,199 67,22,94 In Excel, is there any way I can use this to …
excel vba rgbI am trying to write data to a csv file with java, however when I try opening the produced file …
java excel csv export-to-csv