Does anyone know where I can find a good mapping tool to use in connection with Access data? Similiar to Mappoint but not even as detailed/in-depth. Anything that would work with Access or Excel would be really what I need. Thanks! ...
Hi, I have a regular Excel spreadsheet with only 1 column. I want to export it to a text file with a separator. I am not interested in separating columns, since I only have one. My concern is to export with separators instead of line breaks so that my final result is a simple list like this "item1","item2","item3"... and so on. item1, i...
I can link the results of an existing table/view to an Excel spreadsheet (by choosing the table from the "Select Database and Table" window of the ODBC Wizard, however I'd like to execute a raw query instead. I would like to generate a query (as a string) based on cell values. Then, the user could manually "refresh" the data table whic...
Hi, i need to generate an excel sheet from an excel template which contains drop down lists. I need to use the template and populate the with data from datbase and select the appropriate value from the drop down lists and generate the new excel sheet. I am in very bad situation and need it asap. ...
I would like to build an excel VBA program to find all the match values from a table and print the finding on a column... I tried to use vlookup but only gives me the first location that finds... and I would like all the finds. here is an example: my table starts on cell A2 column A (number) 0084 0084 0085 0085 0086 0087 column B (l...
I have values in column c that i want averaged if they occurred in the last seven days (corresponding dates in column a). i can't get the averageif function to work properly, as I need each individual piece of data to be evaluated separately if it falls within the last seven days. this seems like a function that would be used all the tim...
I am migrating the excel sheet which has different data types using ssis But data format is changing in source level itself My excel sheet looks like below: COL1 Null 1/1/2009 Null 1/2/2009 11.99 123.99 When i see in the source preview it self i am seeing data like COL1 Null 1/1/2009 12:00:00 AM Null 1/2/2009 12:00:00 AM 12/30/18...
I've to create hyperlinks in Excel as above. On click of the hyperlink, the data should be populated somewhere down the excel. Am using Apache POI to generate the excel. is it possible with POI or other tools to generate such hyperlinks. ...
I have to write an application in Visual Basic.Net that will open an excel file, run through the contents an export a test file for processing. The application works great for me (Windows 7) but when transferred to a WinXP PC gives the following error: HResult 0X800A03EC I can replicate this error by making the Excel Application visib...
in Excel , in my pivot tables when i drop down the row fields, value filter option is disabled any idea why ? ...
Hi, I'm using Apache's POI to manipulate Excel (.xls) files with Java. I'm trying to create a new cell whom content is the result of a formula as if the user had copied/pasted the formula (what i call the "relative" way, as opposite to "absolute"). To make myself clearer, here is a simple example : Cell A1 contains "1",B1 contains ...
Hi! Can you tell me how to parse xls file, which contains groups(outlines) using ODBC or COM ...
I've got a bunch of Excel documents that have data on one sheet and a chart produced from the data on another sheet. I'd like to take those documents and produce a series of HTML pages from them. Using POI (or HSSF) know I can read the data from the documents and produce a chart using some charting engine. But the customer's not happy wi...
How can I read an XLS file from VB6? I don't want to use ADO or Automation. ADO isn't going to work for my particular XLS files, because it guesses the data types of the columns from the data in the first few rows. Automation is out, because Excel may not be installed on the machine. I'm hoping for recommendations based on experie...
I am doing a lot of similar tasks among some VBA scripts I am writing and would like to develop a library (a bunch of convenience functions using the typelib I'm working with) which I can call from all my various scripts. I am new to the VBA world and do not know how this is done and have had a surprisingly hard time trying to figure it ...
I am tasked to develop a very simple web layer for a very complex algorithm that is implemented as an Excel worksheet. This script would be called from a Ruby on Rails app that would be presenting the user with the forms, check validations and whatnot, and should return just a number. After perusing this site, my best shot is to auto...
Hi, I have the task of developing an application to pull data from remote REST services and generating Excel reports. This application will be used by a handful of users at the company (10-15). The data load can reach 10,000-200,000 records. I have been debating whether to use Python or C#... The only reason I am considering Python is ...
Hi As the title says, I am looking for source code that shows how to read(write) MS Excel files in pure C (OS agnostic). I have seen some Java code (e.g. JExcel) and would use that if I can't find some existing C code with similar functionality. What I need is to read an Excel file and convert it to XML (or some other more manageable f...
Generating normal columnar data in excel file is quite easy but does any one of you have generated excel files having datas in different blocks placed in different sheets and beautifully formatted without having to manipulate the excel file using COM [which i want to avoid]. Any ideas would be really helpful. The output excel file sho...
Hi, I want to test againts multiple command line arguments in a loop > python Read_xls_files.py group1 group2 group3 No this code tests only for the first one (group1). hlo = [] for i in range(len(sh.col_values(8))): if sh.cell(i, 1).value == sys.argv[1]: hlo.append(sh.cell(i, 8).value) How should I modify this that I ca...