I want to build a utility that can import data from excel sheet(columns are fixed but sheets can be any number) to oracle db. Can you suggest how should I: Read excel sheets(n number)?(Best way) Validate data? Bulk insert into DB? My concern is performance here. Each sheet can have 200,000+ rows. PS - please remember I am a complet...
I'm not too familiar w/ the PIA assembly's for Office interop (Office 2007) and via .NET/C#, I need to open a workbook and save the first sheet within it as a tab delimited text file. Can someone instruct me on how to do this? Thanks! ...
For something i was trying to do in Excel i was suggested to use a ado script. i was given the ADO script as well. But I have no idea where do i put this script in excel. Can anyone please help? Thanks ...
Hi, In my report there is a table control and have header for each column of table. When I open report, it display column header on each page. If i export this report in PDF format, it is showing column header on each page but if I export it in WORD format, it shows header on first page only. WORD showing multiple pages but column heade...
We're using workspaces (tied to calendar entries) for our meetings. It looks like attendees have to be added individually, on a per meeting basis. Is there an easy way to import the attendees (from excel, or a text list). Importantly we'd like to import them all at once, not have to add each person individually to each meeting. A sim...
We generate HTML from text in an Excel spreadsheet. The text contains unicode representations of international characters. When we use VBA to extract the text and output it to a file, it is written as ANSI (ASCII). Is there a way to preserve the unicode representation using VBA? Bruce ...
I am looking for some examples/advice on how to write a Perl script to read data from an excel file then use the data read in (as a string hopefully) and pass it to another Perl file (as an argument). The goal is to have a table in which the user can type some data (ftp destination or filename) into the table. Then my program will grab...
I have been told that there is a bug in the Excel ODBC drivers, that prevents ODBC from providing updates while Excel has the spreadsheet open. Can someone tell me if this is true? Is there a known work-around? Thanks, Ken ...
Hi all. I have an Excel 2007 xlsx file that I would like to programmatically convert to an .xls file. The xlsx file is an export from a reporting tool, and I would like to convert it to xls for better compatibility with the software stack of my application users. The xlsx is as plain as it gets. Just rows with data and basic type inform...
I'm making an application that converts our data structure to an excel file. We're currently using POI to do the conversion. The problem is that the Cell only supports Strings, Numbers and formulas, and our data structure supports images. Is there a way to add images to cells? ...
Hi, Does anyone know how to export results from more than one query into different sheets of the same Excel workbook using the report automation in TOAD for data analyst? Thank you ...
Hello, Application.Run "MyWorkBook.xls!Macro1" will work (run the macro called Macro1 in the MyWorkBook.xls file) Application.Run "My Work Book.xls!Macro1" will not (if the workbook name contains spaces, Excel says "the macro cannot be found"). I just spent hours figuring out that it's the spaces causing this problem... Is there ...
I'm using SSRS 2008 and I have a financial report. I would like the dollar amounts in my table to be in currency or number format when exported to Excel. Currently they end up being text. I have trying a few things to see if its even possible. I removed the table header, didn't use the $ sign, and converted the field to decimal, but no...
Hi, I have 2 sheets sheet1 and sheet2 in an excel 2007 file. In sheet2 I have a column that is managed by a form/macro(with a tree view control). When an element has been selected, the cell is filled with an "x", when it has been unselected, the cell is filled with "" (nothing). In sheet1 I want to create a column equal to the sheet2 ...
I have two columns in Excel. In the first column I have a master list of email addresses. In the second column I have a list of email addresses that I wish to remove from the master column. Please can someone help me so I can remove all the records from master column using the second column? ...
I've generated an Excel spreadsheet using HSSFWorkbook, then implemented a custom javax.activation.DataSource to attach the spreadsheet to an email. However, upon opening the spreadsheet in Excel, it crashes. Excel can recover some of the data, but it loses most of its formatting. ...
When using Team Foundation Server & Visual Studio - you can export data from the TFS database to excel, modify the values, and click "publish" to send the new values back to the database. So, excel becomes a way to view and modify your database table. The feature works surprisingly well and I'd like to use for other databases we have. ...
I've recently taken it as a project to teach myself how to program in Python. Overall, I must say that I'm impressed with it. In the past I've typically stuck to programming in VBA mostly for MS Excel (but also a bit in MS Access and Word) and have struggled to find ways to make it do things that Python can easily do with a single comm...
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving the file as an "Excel 97-2003 Workbook"....
How can I import xml file to existing excel template. I have a map (xsd). It has to be done on server. I used excelPackage , but couldnt find any documentation for the classes. More specific question: how do I write in C# the following code from VB.NET Dim xmlSchema As String = "c:\Schema1.xsd" Map = XL.ActiveWorkbook.XmlMaps.Add(xm...