I have an excel sheet (located in classpath), which has scenarios to be read and executed, and once they are executed, I should write back to the SAME excel sheet saying whether the scnario is "PASS"ed or "FAIL"ed. How can this be accomplished? Please help me its URGENT. (NOTE: I am able to read the excel). ...
I have been tasked with creating an addin for Excel 2007 that reads data from a custom data source. I already have the code that reads the data. It's written in C# and returns objects. This is for a banking system and I cannot give direct access to the data. A userID, password and hardware generated key must be provided to the C# DLL to ...
Hi guys, Every monday end user opens Excel 'prices.csv' and does insert/update/delete on products and their new fresh prices. After that he performs export of 'prices.csv' to MySQL DB into table called PRODUCTS. I've seen here many solution using CSV or using commercial solutions for this. I understand that this can be easily done f...
I'm trying to set Excel cell colors using Apache POI in Java. I played around in Excel itself and chose the colors I wanted - but I can't figure out how to use those colors with POI. I'm using the font.setColor method, which takes a short that's the index of a color... Which seems to indicate that I'm limited to the constants in IndexedC...
VS has started to reject this line oSheet.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape; at runtime. The reason seems to be that it is looking for a printer which is not connected. How do I make it look at the default printer? ...
Hello, I wish to pull data from a large SQLite database into Excel. I'll want to do so quite interactively so don't want to export CSVs or anything like that. I have seen the sqliteodbc website on ch-werner.de but does that work with Excel 2007? What are the best options? Thanks. ...
When I write a whole table into an excel worksheet, I know to work with a whole Range at once instead of writing to individual cells. However, is there a way to specify format as I'm populating the array I'm going to export to Excel? Here's what I do now: object MissingValue = System.Reflection.Missing.Value; Excel.Application excel =...
Hi all i have the following code: Now what this code does is it gets the results from an SQL query and inserts them in a predefined cell which i specify in the code...what i want it to do,.,,is to insert the result of the query in a cell that the user chooses when he clicks on a button which i assign the macro below. So the flow would be...
I need to connect to Excel table through TADOConnection, and I don't know what to write into ConnectionsString property. For Excel Version 8 I use Jet, for 12 I use ACE, what about 11? And how should connectionstring look? ...
I am creating a ListObject in Excel using VSTO as follows: ListObject lo = ws_vsto.Controls.AddListObject(range, "MyList"); (The range variable is a previously defined range.) If I then loop through the worksheet Controls collection I can find that ListObject. However, if I save the workbook and reopen it, the Controls collection is...
Hi all, I have an XLS file with the following rows: store name - idtype1 - idtype2 - idtype3 store 1 - 1a - 1b - 1c store 2 - 2a - 2b - 2c There are actually 5 ID types and over two hundred stores, there are also columns such as address, email etc. What I need to do is load this data into two tables,one bei...
I have a need to run a piece of code every 120 seconds. I am looking for an easy way to do this in VBA. I know that it would be possible to get the timer value from the Auto_Open event to prevent having to use a magic number, but I can't quite get how to fire off a timer to get something to run every 120 seconds. I don't really want...
I am hitting a limit when I try to assign a sum to a cells formula: cells(y,x).formula = "=sum(G65,H74,I38,J20,G22, .... ,K19,L22)" It seems as though I can't have more than 30 summands in a =sum formula. Is there a workaround for this problem? ...
When creating a chart in a spreadsheet using Spreadsheet::WriteExcel, the file it creates keeps coming up with an error reading Excel found unreadable content in "Report.xls" and asks me if I want to recover it. I have worked it out that the problem line in the code is where I actually insert the chart, with $chartworksheet->inse...
I have an XSD file which contains the schema for my XML. The XSD file contains an xs:Enumeration definition, which allows me to choose between 5 options as a value for one of the nodes. Now, we want to be able to generate this data through Excel, so that non-technical people can create it. When I import this XSD file into Excel, i want...
I'm trying to parse CSV files uploaded by the user through PHP, but it's not working properly. I've uploaded several properly formatted CSVs and it worked fine, however; I have many users trying to import CSV files exported from Excel and they are having problems. I've compared the files to mine and noticed that the Excel files all lack...
Hello, I have many cells where data is broken up into many lines; some of those lines are blank. Is there a VB function or formula to remove blank line breaks in Excel cells, or all line breaks? Many thanks! ...
I can make a simple HTML table in a plain text file, including some simple styles, and open it in Excel, and Excel loads the table cells into spreadsheet cells and even interprets colors/styles. I'm using the latest version of Excel. How long has this feature existed? What's the oldest version of Excel that can load HTML tables? And ...
I am making a primitive database in Excel and need a routine to run in the background constantly. I will be able to fill in the actual actions it needs to do, but I don't know how to make something run independent of a key press or some sort of Macro. If someone can give me an example of code that runs independently which I can simply fi...
I need to export data in a sheet to a text file without changing the file name (i.e. not doing "save as". Also it would be great if the file name could look at the previous like file name in the folder and increase by 1 digit (i.e. :file_1.txt, file_2.txt, etc.)... Thanks!! ...