I am reading excel file and for that I do have connection string in App.config but I want to read each day the excel which is today's excel.. Each excel name is today's date(MM/dd/yy), so datasource name is somewhat dynamic. how to write the connection string in App.Config then I want to use something like <add name="Excels" connectio...
Hi, I need to built a console application that will convert all excel 2003 templates to excel 2007 template Any help is appreciated Thanks Aman ...
I have 5 graphs on a tab refering to Sheet ABC. I am duplicationg the tab with the graphs and then making this new set refer to Sheet DEF. The series ranges are exactly the same, it's just the name of the tab that changes. It's taking a while to go through all the series and replcaing the ABC with DEF. I tried a find and replace and it...
I'm trying to execute multiple statements on a MySQL server and get the results into an Excel pivot table. As an example: create temporary table if not exists a select 1 as testcol; select * from a; Even if I have the MULTI_STATEMENTS flag set to 1 it returns a "problem obtaining data" error. Is there a way to do this? It's a read-o...
When I use Microsoft.ACE.OLEDB.12.0 for access to Excel file Is it require Office 2007 to be installed on the machine or it is enough if it is instaled just AccessDatabaseEngine ?? ...
Given A search key --------------------------- | | A | B | C | D | --------------------------- | 1 | 01 | 2 | 4 | TextA | --------------------------- An Excel sheet ------------------------------ | | A | B | C | D | E | ------------------------------ | 1 | 03 | 5 | C | TextZ | | ------------------------------ | 2 |...
Hi all, i have a column like the following: 1 red 2 blue 3 red 4 5 blue 6 7 8 white the blanks refer to the record above it. so #4 would be associated with red and 6 and 7 would be blue. is there an easy way to fill in the blanks for entire column? thanks, rod. ...
I have a client that has a simple yet complicated request for an excel sheet setup, and I can't for the world thing of where to start. I'm drawing a blank. We have a data range. Example: Quarter Data 2010Q1 1 2010Q2 3 2010Q3 4 2010Q4 1 I have a chart built on top of that. Change data, chart changes, protec...
Hi everybody, I need a clone of excel correl() function in java, I found apache math commons library that has some functions in org.apache.commons.math.stat.correlation package, but not sure if they are the same, some docs says that excel correl() function is very similar to PEARSON() excel function but not quite the same, anybody famil...
I fear this has been beaten to death, but I'm still struggling with the problem of reading Excel files in my ASP.NET application that has recently been ported to Server 2008 and 64-bit. Many posts I find point to the existence of 64-bit Microsoft drivers here: here and here. My concern is the warnings I'm also reading about these not...
I have a directory structure where I am managing the requirements of a system with each component of that system having its own directory. the requirements of each component are stored in a excel workbook that has multiple worksheets(# of worksheets are static). I am currently using access as a central location to view the information ...
What I am trying to do is save myself some time from entering 20 cells worth by entering the customer code. Example: customer address phone contact peg 12 fir street 555 555555 Al Basically, I have to enter some of the same names on a shipping document everyday including addresse...
Hi all - I've been trying to get this Excel function working correctly, and I've hit a wall. I'm trying to calculate the exact difference in days between two dates, taking the start time into account as well as the start day. Seems like this should be a common need? Example: Start Date End Date Expected ...
A friend of mine has a very complex Excel spreadsheet with many formulas and lots of data that he uses for work. He wants to put a custom GUI on top of it and then wants to sell it to other people in his profession. Basically he wants to make some freestanding software out of his spreadsheet? Is there any way to put a custom GUI on top o...
Hey all, I have an excel spreadsheet that contains entire addresses packed in a single cell without delimiters. The addresses look like this: 2701 NW 64TH TER MARGATE FL 33063-1703 901 NE 8 ST HALLANDALE BEACH FL 33009-2626 1840 DEWEY ST UNIT 305 HOLLYWOOD FL 33020 3049 NE 4 AVE WILTON MANORS FL 33334-2047 650 NE 56 CT OAKLAND PARK ...
I need a way to programatically launch the macro-recorder in Excel, and supply the name for the new macro that will get created. This can be from VSTO or VBA, or using the Office interop assemblies. Any ideas how this can be accomplished? ...
Are there any options available to do offline surveys and questionnaires. Something in the line similar to Adobe Lifecycle that allows coded pdf files. Its costly and there are about 10-15 templates which will also add up to the license cost. MSWord and MS-Excel are options but there could be users that do not have these installed or us...
I have created an Excel Sheet that does some lookups to format data that needs to be inserted into another table. This Excel Workbook needs to be given to some users that are free to add some new rows, and then need to be able to hit an "Insert Into Database" button and have the records transformed and inserted as new records into a SQL ...
I am reading an excel file in C#.NET. The data is being read successfully but there is problem with some hyperlinks stored in the excel file. I can read their text but i dont know how to get the underlying link/url of the column. I couldnt find much help on google as well. if someone has worked in a similar situation please let me kn...
I am trying to attach a unhandled exception handler for .NET excel addin. The problem is the exception handler is never called. AppDomain.CurrentDomain.UnhandledException doesn't work - never fires the event. Application.Current.DispatcherUnhandledException can't be used as Application is null in the excel addin code. how do you wire...