What is the best way to convert a table within an HTML document to an excel-readable file? I would like this to be a command-line tool that I can call in bash on my mac, as I'd like to batch process a bunch of HTML files. I know I could write a script to do this fairly easily, but am looking for generic, existing tools that can be call...
How can an excel file be opened, all cols/rows read in an array etc the same way .csv files can be? Is there any built in libraries/classes for that in php? ...
I have a large amount of data to insert into an worksheet of an existing Excel workbook. The Excel workbook will have other worksheets containing calculations and a pivot tables. The data may have as many as 60,000 rows and more than 30 columns. This solution must work for both Excel 2003 and Excel 2007. Using the Excel OLE object is wa...
How to read an Excel file using C#? I open an Excel file for reading and copy it to clipboard to search email format, but I don't know how to do it. FileInfo finfo; Excel.ApplicationClass ExcelObj = new Excel.ApplicationClass(); ExcelObj.Visible = false; Excel.Workbook theWorkbook; Excel.Workshe...
Is it possible to set up the headers in a multicolumn listbox without using a worksheet range as the source. The following uses an array of variants which is assigned to the list property of the listbox, the headers appear blank. Sub testMultiColumnLb() ReDim arr(1 To 3, 1 To 2) arr(1, 1) = "1" arr(1, 2) = "One" arr(2,...
In my Excel spreadsheet, I've got a cell that is =SUM(C6:C19). If I go to C20 and add a row, that formula will not adjust. I want it to change to =SUM(C6:C20) ...
I notice that Project 2007 has the functions that allow operations that can be undone to be placed in a single stack item, or "undo transaction". For example: Application.OpenUndoTransaction "Create 6 tasks" Dim i As Integer For i = 1 To 6 ActiveProject.Tasks.Add "UndoMe " & i Next Application.CloseUndoTransaction What this means ...
I'm trying to AND two hex number bit-wise in Excel/Visual Basic. Ex. 53FDBC AND 00FFFF which should yield 00FDBC. Any ideas on how to do this? ...
Hello, I am an excel newb, wondering if excel has built in functionality to do the following. Turn this data: Name | Activity | Option Bob | Monday Activities | Golf Bob | Tuesday Activities| Kayak Marge | Monday Activities | Spa John | Tuesday Activities| Soccer Liz | Tuesday Activities| Spa Into: Name | Monday A...
Hey all Is it possible to create worksheet functions dynamically in C#, that is, without using the method attribute approach? Or is this something that's only supported using an XLL? What I'm looking at achieving is to retrieve a functions list (along with parameters) from a source and register these functions. These functions will jus...
Good morning, I have a .Net 2.0 runtime DLL that I am trying to load from Excel (it's correct regasm'd). I've verified with the Fusion Log Viewer that it is trying to load with the 1.1 runtime instead o 2.0, which explains why it's failing. One solution is to put an EXCEL.EXE.config file next to excel that looks like this: <?xml vers...
Is there any way, in either VBA or C# code, to get a list of the existing macros defined in a workbook? Ideally, this list would have a method definition signatures, but just getting a list of the available macros would be great. Is this possible? ...
I need an algorithm to convert an Excel Column letter to its proper number. The language this will be written in is C#, but any would do or even pseudo code. Please note I am going to put this in C# and I don't want to use the office dll. For 'A' the expected result will be 1 For 'AH' = 34 For 'XFD' = 16384 ...
Hello there, i have a report that i would like to send via excel. it will include the recipitents, subject and the information in the body. actually it could copy the cells in question. what i did so far is create a button and assign a macro to it with this code: Private Sub CommandButton1_Click() Application.Dialogs(xlDialogSendMail)....
How to copy the data from Excel to oracle? ...
I have files with tons of real time data that I process with an C# application. After processing the data it is presented in Excel using a specific template. This is solved using Interop today. I must say I don't completely gasp the whole Interop situation. Do I have to manually install the Interop functionality on each end user termina...
I built an excel model used to analyze real estate transactions. I would like to create a user interface to overlay the model so that the file can be distributed to clients to evaluate potential investments The interface will serve two primary functions: 1)Enhance the user experience by creating an easy to follow input page. The enter...
Is there a simple way to do this, via macro or otherwise? By calculated field I mean a field that is computed from other fields, versus raw entered values. By highlight I mean colored differently. I need this to better understand a large spreadsheet from a client. ...
I have a piece of VB code that dynamically finds my current file path in Excel. Now I wish to use it when importing text from a text file, but can't figure out just how to code it. Here is my code for getting the current path: Function GetCurDir() Dim str As String Dim pos As Integer str = ActiveWorkbook.FullName pos = InStrRev(str, "\...
Hi, In my SSRS report when i give the border as 'Solid', it gives a thicker border in its excel version than the excels normal border width. Did any one come across a situation like this. What is the possible solution to avoid this. Please, I would appreciate all your help on this. Thanks in advance. Suni ...