I have a macro enabled work book and i change the name of the .xlsm file to [FileName].xlsm.zip and then i unzip i get some folders I then put these extracted folders in to another folder and zip it back and rechange the extension to the previous xlsm format i now try and open but i get an unreadable error. I am not changing any content...
I copy search results of Google and want to stick it on Excel now. I was able to write it to the place to search in IE, but do not understand more than it. Sub get() With CreateObject("InternetExplorer.application") .Visible = True .navigate ("http://www.google.com/") While .Busy Or .readyState <> 4 DoEvents Wend .document.all.q.Value ...
I have a .NET 2.0 COM object that's used by VBA in Excel. It works fine on my dev machine, but when trying to use it on a clean VM workstation I get this error: Automation error. The system cannot find the file specified. The dll is registered with "regasm /tlb /codebase mycom.dll" and not put in the GAC. I don't have administration r...
Hi, I need to import some Excel spreadsheets into Java objects. I will use POI to do the task (an old version of it unfortunately). However I wonder if there is some high-level framework to do the same task but declaratively. I'm thinking in Castor and XML. The mapping Excel-Class will be stored in a resource (e.g. an XML file). Yes, I'...
On a django site, I want to generate an excel file based on some data in the database. I'm thinking of using xlwt, but it only has a method to save the data to a file. How can get the file to the HttpResponse object? Or maybe do you know a better library? I've also found this snippet but it doesn't do what I need. All I want is a way t...
I am looking for a way to programatically convert Excel reports to XPS format. Is this supported anywhere in the Microsoft framework, or should we look for a third party tool? Yes currently we are programatically creating Excel reports using ExcelWriter and need to produce XPS reports for a client. So we either go direct to XPS which ...
I have an Excel spreadsheet whose first column is mostly numbers or a combination of letters and numbers. These are codes relevant to my business area: 28 38 48 L2 A7 BC etc. The column is formatted as text in Excel. I want to use this as a data source in SSIS for SQL Server, but when I add the object to a Data Flow designer, it forc...
Hi there, I know how I can do this for the simple case as details here: http://geekswithblogs.net/Denis/archive/2007/01/03/102623.aspx But what I'm trying to do is when my category is selected in Excel I want to be able to dynamically populate the function list at run-time. As is, it's populated using all public function in the catego...
Hi there, Is there any way of programmatically accessing the Excel Fucntion list of a UDF so I can dynamically add more enteries to it? ...
Hey I got the requirement to output some reports as Excel 2002 spreadsheets. Normally a job for reporting services - however - that's (edit) "not great IMO" and I hate it so for this project I used ExtJs - which doesn't do any excel output - not really - but does do the UI really, really well. The reports will need to have outlining, ...
I want to count how many rows have the sum value no greater than X. Same as this http://stackoverflow.com/questions/839704/sum-until-certain-point-mysql but just with an excel formula and only the row count. Using the same examples as in the above, first limit should give the value 2 and the second 4. ...
I am using Excel 2003's XML Data Source and exporting the data using the menu option Data -> XML -> Export. The data exports fine, but the resulting elements are indenting using tabs. This may sound trivial, but is there a way I can set the formatting of the indents to spaces? ...
I'm attempting to convert some VBScript to javascript, but I doubt it's possible because it seems to be specific to MS apps and code. I'd like help with either of the two possible outcomes: a) actually converting the code to javascript, or b) demonstrating that converting it to javascript is currently not possible. The specific VBScript...
I have a PowerPoint presentation w/ an embedded Excel Workbook, name: ThisWorkbook I need to export ThisWorkbook into an Excel File. Thank you ...
Hi People I I'm have small headache caused today by excel and the way it takes control of everything. I have two time values I need to add together then divide by a value I got charged for that time to work out how much it cost me an hour. so say I was charged day on for 12:30:00 on day 2 I was charged for 13:20:00 and day 3 I was ...
I am trying to use code to filter a spreadsheet dynamically, based on the current date. I am storing the date I need to filter on as "CurrDay" and I'm attempting to recall that stored date back into my filter algorithm. It is not working and I need to figure out how to do this to finish up this code. Everytime I run the code it retu...
I am working with Window Service project. that have to write data to a sheet in Excel file in a sequence times. But sometimes, just sometimes, the service throw out the exception "Exception from HRESULT: 0x800A03EC" while it's trying to get range with cell's name. I have put the code of opening excel sheet, and getting cell here. OS:...
Hi there, Let's say I have the formula =MyCustomFunction(D2), where MyCustomFunction is writen in an Excel AddIn using C# How can I, in a sensible way, tell my formula to re-run when cell D2 is changed? ...
Hi, I am looking for a control that does the same as the user Defined Function control in Excel So for example when you click on "Average", a control pops up allowing you to type in 2 numbers in text boxes. In the right hand side of the text boxs there is a button that when clicked allows you to select a range of values in excel and w...
Hi, i wanna convert any Excel or Doc file to PDF with C# (ASP.NET) .. Is there any component or any other solution for this ? Thanx ...