Hello All: I am pretty computer illiterate so please excuse my ignorance I am trying to download data from a particular website in MS Excel. Web link is: http://www.nseindia.com/marketinfo/companyinfo/eod/Shareholding/shareholding%5Fmain%5Faft%5F31Mar09.jsp?nds%5Fid=15836&symbol=HDFC&count%5Fstring=0%7C12%7C0%7C0%7C0%7C0%7C0%...
I'm able to save the excel file as .csv using perl like this : print "Content-type: application/vnd.ms-excel\n"; print "Content-Disposition: attachment;filename=\"file name.xls\"\n\n"; print"Fruits, Cost"; #then looping on the results. Yet I need to save this as .xls cause I want to use colors. Any one can help? ...
I'm having some trouble with Excel formats: Example: Value: 13 Expected result: 13 (not 13. ) Value: 13.5 Expected result: 13.5 Value: 13.1234 Expected result: 13.1234 Right now I'm using #.# format, but for the first value it always formats with the . character at the end. Any ideas? Edit: We need to have this working for different...
I'm using the Apache POi HSSF library to import info into my application. The problem is that the files have some extra/empty rows that need to be removed first before parsing. There's not a HSSFSheet.removeRow( int rowNum ) method. Only removeRow( HSSFRow row ). The problem with this it that empty rows can't be removed. For example: ...
I'm using JExcelApi for generating XLS files. From jxl.format.Colour, I see how to get any of the colors in the "standard Excel colour palette", but not how to create a new color (say, given its RGB). But in Excel itself, I can pick any color at all. Am I just missing it? Is there a way in JExcelApi to select an arbitrary color? I'm...
I wrote an ASP.NET page that imported data from an Excel spreadsheet without any problems. Then I moved it to the server and found out that it didn't work on a 64 bit OS. After some Googling I found that MS does not have nor will it ever have a Jet DB driver for 64 bit OS. Does anyone have any suggestions for a way to easily import da...
Application level events and processes in Excel are restricted to a single instance of the application. In the past I have prevented users from opening more than one instance of Excel when my add-in is running using the following code. Private Sub KillDuplicateProcesses() Dim objWMIService As Object Dim colItems As Variant ...
Hi everyone, Have a list of dates in excel in the format (this comes originally from csv): 23/11/09 07:27:02 23/11/09 08:01:50 23/11/09 08:38:58 23/11/09 09:40:01 What I want to do is count the number of these falling between hour blocks, like 7-8, 8-9, 9-10 etc Not sure how to get started, but one idea was just to put logic statemen...
Hi, In my application, I need to generate excel files on the fly. I have an option of using Excel library. But it is mandatory to have excel installed on the machine. Is there any other .NET API to generate excel files at runtime which doesn't require excel. Thanks, Mahesh ...
I have an excel sheet with two columns. Eg. ---------------------- A B outputColumn C ---------------------- xxyy dd/mm/yy xxyy Y ---------------------- NA #N/A Y ---------------------- xxyy xxyy Y dd/mm/yy ---------------------- xxyy #N/A N dd/mm/yy ---------------------- . . . I want column out...
Hi, Since a few days I'm using MS Access 2007 in a certian process. In my VBA code I use: CreateObject("Excel.Sheet") In Access 2003 a document was created in 2000-2003 format. Now in Access 2007 VBA enforces the new format. This causes problems in some additional coding. Any suggestions how to enforce older format (2000-2003) through...
Hi, I am looking for a vb script that would list the folders and subfolders from a directory, and output it to excel so that i could open the folders via hyperlinks. I am trying to create a sort of directory index that collates about 100 parent folders from 2 directories located on 2 different servers. Some parent folders have up to ...
I am trying to find a way to make a web application communicate with Excel in the same way that a desktop application could talk to it using COM. The basic description of my problem is as follows: User selects a cell within an Excel worksheet. User switches focus to a web application running inside a browser and clicks a button. The cl...
In my excel file, I have a table setup with formulas. with Cells from Range("B2:B12"), Range ("D2:D12"), and etc every other row containing the answers to these formulas. for these cells (with the formula answers), I need to apply conditional formatting, but I have 7 conditions, so I've been using "select case" in VBA to change their i...
I'm using Aspose.Cells to build an Excel document programmatically. This works great. One of the cells, though, is a block of raw HTML. I'm wondering if it is possible to tell Excel (in any fashion, including the GUI - you don't need to know the Aspose API) to parse and display a cell as HTML. Right now, it just shows up as the raw HTML ...
Hi everyone, I want to edit this query =COUNTIFS('Sheet1'!E2:E465,7,'Sheet1'!F2:F465,2) so that when I drag/copy it sideways, as in, next cell to the right the 2 stays constant and the 7 increments like =COUNTIFS('Sheet1'!E2:E465,8,'Sheet1'!F2:F465,2) and so on etc =COUNTIFS('Sheet1'!E2:E465,9,'Sheet1'!F2:F465,2) =COUNTIFS('Sheet...
Is there a tool to convert a large number of excel files into tab delimted files automatically? ...
I have a ASP.NET application that allows users to export their staff's absences each month to Microsoft Excel. The application is currently generating the following exception Exception: Cannot create ActiveX component. with the following stack trace System.Exception: Cannot create ActiveX component. at Microsoft.VisualBasic.Interacti...
I have a worksheet with a large number of cells containing large amounts of text. Within any particular cell there may be some text that is coloured red. I want to remove that text and copy it to a different column. I have a VBA function that does this by checking the cell contents character by character but the spreadsheet is quite lar...
I have a stored proc that I use to create an xls file and then write data from queries to it. I can't take credit for this, here's the source http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/ . I can write varchar, txt, etc without issue. I can't seem to get any datetime fields to write and I have guessed at al...