excel

POI Auto Filter

How do I use Apache POI to pre-define an auto-filter region in an Excel 2007 document? A small code example or link would be nice. ...

opening worksheet in background

here's the process that i am running from a macro: i open a worksheet i add data to the worksheet i save it i close it and i repeat the steps: 1, 2, 3... etc. (when i say I, i mean the stupid macro) is it possible to open the worksheet in the background so that the user doesnt actually see that the worksheet is being opened? ...

How to read excel file where office is not installed(C#3.0, dotnet 3.5)

Hi I am facing a problem. In my server, there is no office installed. However, I need to access data from excel file. I used Microsoft.Office.Interop.Excel dll file. I am under the impression that this will work because the dll location is C:\Program Files\Microsoft Visual Studio 9.0\Visual Studio Tools for Office\PIA\Office12\Micros...

How can I change cell style in an Excel file with ExcelLibrary?

Hi all! Can anybody help me with ExcelLibrary? I'd like to set a cell background and font color, but I don't know how can I do it. I try to get access to a cell style, but I didn't found it. Anybody have any ideas? ...

Creating a table in excel

Hey guys, I was working on project for my company. The requirements are to create an excel report at the end. The way I am currently coding/thinking. Remote Server ---> Local Access table --> give user a UI to filter data however they want --> Export to excel. However, one of my analysts asked me if we can stay away from access an...

filter excel worksheet based on records form a 2nd sheet

I have an excel file that is a SEO report of a website. But the tool that generated the report included everything under the sun and most of it is junk. I want to filter out the important info such that I keep only records in the first worksheet that correspond to a record in a second worksheet. Basically I want to keep all the records ...

datetime issue with xlrd & xlwt python libs

I'm trying to write some dates from one excel spreadsheet to another. Currently, I'm getting a representation in excel that isn't quite what I want such as this: "40299.2501157407" I can get the date to print out fine to the console, however it doesn't seem to work right writing to the excel spreadsheet -- the data must be a date type i...

Is it possible to load an Excel file to memory?

I have a website where businesses can load items for sale. Then end users can search for that item, and find all the stores that carry it. Most stores sell more than 100 things, and while I do have a form for inserting a single item, it's tremendously stupid to have only this for businesses to offer things. My idea is to have an option...

SSIS Import from Excel - dates in 21-Jun-10 format get inserted as NULL?

I have an SSIS import package that is bringing data into a SQL 2005 database. One of the columns has the date in the following format (dd-mmm-yy) and always gets inserted into the database as NULL. I've tried the destination column as smalldatetime, NVARCHAR, VARCHAR, and always comes in as NULL. I know if edit the column on the sheet...

Can you pull data from a spreadsheet that is security protected?

If our finance department wants us to create a web app that pulls data from a spreadsheet calculation, based on user input, but also want that spreadsheet to be private from all developers working on the app, is this possible? How do companies launch an app with sensitive information that they want to protect? Can you access data from ...

Removing hyphens from a cell in Excel

I am looking to take the hyphen or dash out of a birthdate. 01/01/01 01-01-01 I need to combine the birthdate with other fields and it can't have the seperator in it. I am sure there is a better way. I can get the month and year out, using left & right however I can't figure out how to get the middle out. Below is what I have so far and...

Get Timezone Information in VBA (Excel)

Hi I would like to determine a time offset to GMT/UTC (including daylight saving time) for different countries at a specific date in VBA. Any ideas? Thanks ...

Question regarding optimal excel function implementation

Hi everyone, I have a question about Excel! I hope that isn't too unconventional for this site... So I have an Excel table with several thousand rows. It is kind of setup like a db in that the first three of my four columns have numerical values identifying the sequence or order that the content or fourth row contains. I am running int...

find bold text in excel sheet using C#

How to find bold text inside cells of Excel sheet? I'm using C#, OLEDB and ADO.NET for reading xls file, but I don't resolve how to resolve my task. Do I need to use Iterop.Excel? ...

Print a range of hyperlinks

How can I get this to print the hyperlinks files found in columns "D:E" by selecting the rows in column "A" Sub Print_Hyperlinks() Dim rng As Range Dim row As Range Dim cell As Range Dim LastRow As Long LastRow = Range("A2").End(xlDown) 'Print only selected rows in "A" Set rng = Range("D2:E" & Last...

Creating a custom ODBC / OLE driver in C#

Does anyone know how to create an ODBC or OLE driver preferably in C#? What I want to do is creating a custom data source which I can use in Excel and Access. Or do think of another way how to do this? Thanks in advance for your responses! ...

Excel interop - how to stop number (stored as text) being "evaluated"

I was wondering if anyone had come across the following problem and had any ideas on how to resolve it: I'm exporting data from a C# application (.NET 3.5) to Excel (2003) via Interop. One of the columns stores a string value that appears to be numeric. That is to say it is a number that begins with a 0 e.g. 000123 I need the full num...

How to read Excel cell having null values too in Java...???

I'm using Apache POI 3.6. I've a column which is blank. I want it has to be read and then to the next cell. Even if I could resolve NullPointerException problem I could not get to the next cell. Here's my code snippet : HSSFCell cell = row.getCell(c); String value = null; switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_FORM...

How to write data to an excel file?

I have some data that I'd like to save in an excel file. How does one do this in python? ...

how to set the active sheet using Excel PIA

Hi, I'm using multiple sheets within my Excel application and want to activate (set focus on) a particular sheet upon exit.. Basically I want to set ActiveSheet property on my workbook, but since the property is readonly, is there any other way to achieve this? Thanks, Sam ...