Tag Archives: excel

How to add a menu item to Excel 2010 Cell Context Menu – old code doesn't work

Questions: I’ve tried 3 different code samples and they all fail. Here’s the code from a MSFT employee (How to show a context menu on a range), the other two samples have pretty much the exact same code: private void ThisAddIn_Startup(object sender, System.EventArgs e) { CommandBar cellbar = this.Application.CommandBars[“Cell”]; CommandBarButton button = (CommandBarButton) cellbar.FindControl(MsoControlType.msoControlButton, 0,… Read More »

Adding an image from memory stream to Excel document

Questions: I have an image in a memory stream and I want to write this to an MS Excel document, the PIA only exposes the AddPicture method which takes a file path. Is there away to add a picture without having to write the image to disc? MSDN http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.shapes.addpicture(v=office.14).aspx Answers: Well, a bit of blind… Read More »

Download Excel in Backbone.js

Questions: //Download SKU logic downloadSku: function (e) { e.preventDefault(); var checkedValues = this.$el.find(‘.chk:checked’).map(function () { return this.value; }).get(); var options = { success: function (model, response) { console.log(response); var blob = new Blob([response], { type: ‘application/vnd.ms-excel’ }); var downloadUrl = URL.createObjectURL(blob); var a = document.createElement(“a”); a.href = downloadUrl; a.download = “downloadFile.xlsx”; document.body.appendChild(a); a.click(); } };… Read More »

Excel and Tab Delimited Files Question

Questions: I am encountering what I believe to be a strange issue with Excel (in this case, Excel 2007, but maybe also Excel 2003, but don’t have access to it as I write this). I can reliably convert some server data over into a tab-delimited format (been doing this for years) and then open it… Read More »

Export from PHP to Excel

Questions: I need to export data from php to Excel, and be able to format various items in the excel spreadsheet. So far, the best library that I have found is PHPExcel. However, it seems very heavy, and somewhat slow. Granted, it is very powerful. Is there anything a bit more lightweight and faster, that… Read More »

Excel: Check Sheet Dependencies within a Workbook?

Questions: I’m in the process of refactoring a huge workbook woth a lot of legacy parts, redundant computations, cross-dependencies etc. Basically, I’m trying to remove unneeded sheets and implement some proper information flow within the workbook. Is there a good way to extract the dependencies between the sheets (with VBA)? Thanks Martin Answers: You can… Read More »

export to excel in jquery or jqGrid

Questions: I have a jqGrid where I get data at once from server (java) in JSON format. I want the data in the jqGrid to be exported into Excel format. Till now I saw this page which gives me an error in IE ‘o.url is null or not an object’ grid.import.js Also I saw this… Read More »