Hi, I have an addin which I want to invoke through Excel interop from a C# winforms application. I can't get the addin etc. to load unless I uninstall and resinstall it each time (this is apparantly something to do with Excel not loading addins when you use interop - btw, can't get their example to work in C#). Unfortunately this is s...
I need to be able to import the contents of an Excel spreadsheet using the file upload capability. The user must be able to upload the file to the web server which will then open it and import its contents. The steps are: Upload the file Open it and read column headers from the top row Map the columns into the columns I can accept Exec...
I have an Excel workbook with a number of features: One main user-facing sheet One summary sheet based on the user-facing sheet's data A number of graphs based on the user-facing sheet's data (as in, the type of graphs with a separate tab for them, rather than objects within a worksheet - I'm not sure if they have a special name or spe...
Where can I find a complete list of changes in VBA from Excel XP (2002) to Excel 2007? I have a workbook that relies heavily on VBA which I have been working on in 2002, and when I opened it in 2007, I noticed that some things had changed. For instance, my workbook does lots of 3d rotation; I discovered that Shape.ThreeD.RotationX has ...
I'm looking into extending some code that handles automatic opening and reading of Excel files. Ultimately this process needs to be able to run on a server so there is a strict requirement of no dialogs/user interactions required. Currently this is all working fine for normal files, but now I need to be able to extend this functionality...
Hey guys I have a question about a method to break something apart. I get this excel spreadsheet that provides me with data that I need to do one report. Its pretty simple and straight forward, however there is one particular part of it that is giving me some grief. In the excel spreadsheet there is a column that lists "parties envolved...
Hi! I have about 50 excel sheets to input on a website everyday, but unfortunately I can only submit 8 of these sheets per hour. Therefore, I'm looking for a tool, or comnbination of tools, that will allow me to automaticly copy & paste fields from Excel sheets, into a designated form on a website, and will allow me to set the time wh...
hi is it possible to do this kind of things in excel-2007 vb... for example user selects cell or range.... let's say cell G13, now this cell will be displayed on the upper-left corner of the sheet (i.e. where usually A1 resides by default) in the case of range selection the upper-left corner of the range will be displayed in upper-left ...
I have been trying to have the user download an excel file via a download prompt. Everything works fine in firefox and IE7 + but it doesnt work in IE6. In IE6, it displays the name of the aspx page and downloads a blank page. Here is my code Response.Clear(); string fileName = DateTime.Now.ToShortDateString() + "Leads.csv"; Response.Cle...
I've been trying to replace all "#" in a Excel worksheet using a winform application... I tried with something like this Excel.WorksheetClass excelWorksheet = (Excel.WorksheetClass)application.Worksheets[1]; excelWorksheet.Cells.Replace(@"\", "", Excel.XlLookAt.xlWhole, Excel.XlSearchOrder.xlByColumns, false, Type.Missing, fals...
How do you password protect an excel file that is being generated using the CarlosAg.ExcelXmlWriter (.NET C#)? ...
Can I run an update query and in one single field run multiple updates like: "joe doe" updated to 334 & "barry davis" updated to 456, etc basically I want to convert the name to number (in my case it would be the employee ID#), and I have about 500 employees so one at a time is a little out of the question. the table is import from exc...
Is there a way to convince the VBA editor in Excel to stop auto-formatting lines to remove the space at the end when I pause in my typing for a quarter second? ...
Hi, In my application i am making user to upload the excel file. While uploading the excel file i am getting this error "No error message available, result code: E_FAIL(0x80004005). at ". but not all the time this error is coming. sometime this error is coming.I am not able to trace when this error is occuring. Plz help. ...
I'm using OleDb to read from an excel workbook with many sheets. I need to read the sheet names, but I need them in the order they are defined in the spreadsheet; so If I have a file that looks like this; |_____|_____|____|____|____|____|____|____|____| |_____|_____|____|____|____|____|____|____|____| |_____|_____|____|____|____|____|...
How can I run excel from command line / cmd script such that it doesn't prompt if I want to enable macros in the spreadsheet I am running it with? ...
I have an excel sheet and was trying to figure out if there was a way to grab text b/w slashes. For example: [In cell B9] R:\FINANCE-Asia\Q1Report.html I want to pull out: FINANCE-ASIA and place it into cell C9. Anybody know what the formula for this would be? ...
I've got a fairly simple Excel spreadsheet with many rows of data. Each row contains empty and non-empty cells. Is there a simple way to determine the column letter/number of the cell in each row that contains the first non-empty cell. Ideally I'm after an Excel function to do the job, but I can't find one in the help. A|B|C|D|... 1|3...
i'm trying to import an excel file into SQL Server but if any of the column containing number value like "12355484645" and when it's inserted into SQL Server, the value will become "1.05e+010". Beside the methods of adding "'" in front the value or formatting the excel column, how do i convert the format in asp.net code-behind? ...
Using C++ and OLE, how might I go about obtaining the ID of the worksheet that is currently in focus? For example, I have the following code: Variant excelSheets; Variant excelSheet; excelSheets.OleProcedure("Add"); excelSheet= excelSheets.OlePropertyGet("Item", 1); I would like to add a sheet and then get the sheet ...