Hi team, I don't profess to be any master of Excel, so when these things arrive I can generally write a best-effort macro to sort out any bulk updates, but this one has me stumped. When we migrate our reports that connect to an OLEDB source and Cube they are coming across with the following two connection settings: .RefreshOnFileOpen...
Hello, I'm trying to read an Excel file using OLE. The issue is that when the Excel file is located in a Unix share, when I try to read from it, I'm not able to read last row (only the last). However, if I copy the file to Windows beforehand, then it is OK. I think it might be some issue related to big/little endian. Any help would ...
The links appear hyperlinked with blue line in Excel, I want to extract the text from the link e.g. The url http:\sea.craigslist.com appears as "seattle" in excel. I want to extract the text "sea" out of the link and paste in a next column. ...
Dear Concern, I stuck in the issue of exporting excel it gives error System.OutOfMemoryException in excel 2007 we cam export 1000000 rows but while exporting more then 250000 rows its gives the error the logic to upload the excel as i am using is Response.Clear(); Response.Charset = ""; Response.Buffer = true; Response....
Hi! I'm using the following code to generate an Excel file using Microsoft.Interop.Excel. The problem is that I can actually see the workbook generation, when the code is executed, an excel document is open on the screen and the doc starts filling out with data. Can this be done somehow in the background? Thanks Microsoft.Office.Inter...
Hi! I'm using this code to generate an Excel file. It should be simple to change the export to CSV file, just by modifying a parameter in the saveAs call, but it doesn't work. Any ideea why ? Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); xlApp.Visible = false; ...
Hi there, I have a problem I just can't fix. I need to find if a product exists so it shouldn't be treated twice (or more). Here's my code : Dim table As Variant finalLig = Cells(Application.Rows.Count, 1).End(xlUp).row table= Range("C3:D" & finalLig).Value 'two dimensionnal array (nb of products, 2 columns. 2nd column is just here to...
We've got some users who would like to query one of our SQL Server 2008 databases from within Excel 2010. I can see how to retrieve values from a SQL table or view from within Excel, but I cannot see how to pass SQL Server a specific query. Thanks very much. ...
How can I run a macro in an Excel file I open with Perl? ...
Currently I have an application that takes information from a SQLite database and puts it to Excel. However, I'm having to take each DataRow, iterate through each item, and put each value into it's own cell and determine highlighting. What this is causing is 20 minutes to export a 9000 record file into Excel. I'm sure it can be done q...
Hi, I need to read a XML Spread Sheet 2003 in a project and I have a problem with columns. This example show you have king of template my data are : Name Of | FirstName | SecondName | ... | ... Monday | 1 | 2 | 3 | 2 Tuesday | 0 | 1 | 1 | ? Wednesday | 2 | ? | ? | ? ...
Hello All, I am having an issue is that while exporting a report to excel sheet, there are lots of spaces and empty cells between the data, as well as, the cells are merged. Is there is a way to export the report and each field will be in a cell ot to control that exportation, suppose my report looks like this: No Trans_No 1 123...
Hello, I was going to ask my question over at that "Experts" place, but they wanted me to pay $12.95! Fo that price I could pay some college wiz kid to do this for me, and have it done quicker! Ok, this should be an easy one, but for some reason my brain is freezing up when I try to do it. I have a spreadsheet with three sheets in it....
Does anyone know how to do a case sensitive vlookup with excel? ...
How can I use get an excel chart to use a value in a hidden cell as a formula? ...
I am looking for a HASH or maybe something even simpler. I want to return a unique number for every string in a cell. Does anyone know if there is a function in a cell that will return a unique number or a unique string for another string? The problem is I would like to compare whether two string are totally equal, I need to be case s...
There is a code function that returns ASCII for every letter. I would like to use it in a way that it will break up a cell a1 = "some string" Into it's ASCII codes: Something like this: "23423423434634" Sorry I don't know the exact ASCII of that but you get my point. please note that i would like to do this specifically with a formu...
I have been exploring Excel C API and am now good at getting multi-cell input, doing computations and outputing the result in a single cell. Now I want to output the result in multiple cells, for example: 1) Get a column range as input 2) Sort the numbers (in the cells) 3) Write the sorted numbers in a new column or the same column (in-...
Hi guys, I have been working on a dynamic way to create a bargraph where the data can be updated and modified over time which will change the appearance of the graph e.g. If I add a new row it will feed that data into the graph. I have managed to do this successfully when the data is organised vertically e.g. Data column which has the ...
I develop for clients who are still using Excel 2003 on Windows XP systems. Therefore we develop within a Virtual Machine running XP and Office 2003. I often create menu or control sheets within files using Form Control objects, mainly button controls. Sometimes when I open these workbooks up, the controls resize themselves (bigger, sma...