dump mdx query resultset into Excel
Hi I was just wondering if anybody knows how to dump mdx query result set into excel. Thanks, Sagar ...
excel
VBA-Trouble with attaching cells into body of email(Outlook)
Hi, I am using excel 2003 and I am having trouble attaching cells onto the body of an email. I got some of the code off http://www.rondebruin.nl/mail/folder3/mail4.htm but it does not work for me. What happens to me is that a spreadsheet would pop up that has Not Peer Review on it and an error message saying "runtime error '1004' PasteS...
Excel programming module running slow on Terminal Server 2008
I have a Windows application that exports to Excel using the Excel Object Module (programming module). It has worked fine on all Winodws versions except Windows Server 2008. It takes about 2 seconds to do anything in Excel, making the process take minutes or even hours to complete what normally takes a few seconds. This happens when usi...
Excel Sheet to iPhone Data -- Point A to Point B
As simple as possible: I have a very simple Excel spreadsheet with just over 1k records. I want to use this as a static datasource for an iPhone application. What's the best plan of attack? Possibilities in my mind: 1) Reading the XLS directly as a data source: is there an Obj-C lib for this? 2) Converting the XLS to a format that Ob...
XLL plugin's DDEConnect() fails when connecting to Excel?
I have a problem with connecting to Excel, there's a plugin that reads from db and tries to fill excel sheet with data across DDE, and it seems to be failing sometimes on DDEConnect function with error number 16390 - DMLERR_INVALIDPARAMETER Invalid parameter to DDEML function call. What is more interesting it is failing more often when...
How to query Excel data which is in memory using OLEDB?
I have a file upload control on a web page. Users will upload the excel files and in my code, first I save the excel file to the disk and then open it with OLEDB connection and do my stuff. My question is: Is there anyway to avoid saving this file to disk? ...
Function for detecting duplicates in Excel sheet
Hi Guys, I need a function that can detect duplicates in a specified Excel column. I have this one but it does not work properly. It cannot distinguish between the value "46.500" and the value "46.5000". The countif function probably compares cells as numbers. These cells are formatted as text and I have even tried to add an apostrophe ...
Excel OpenText method
I keep getting the ambiguous error code of 0x800A03EC. I've been searching quite a bit to see if I could find a specific reason for the error but unfortunately that code seems to cover a multitude of possible errors. I will copy and paste the code that seems to be giving me problems and hopefully someone will be able to provide me wit...
VisualBasic (or Applescript) Excel Sheet sorting with names
Hi All I have a big problem in the moment. I have to sort out an Excel sheet with names in it. There is always a first name and a last name following each other in the same order. Each name fills a cell. These Cells are alligned in one row. Example Bill|Cospy|James|Bond|George|Clony|Michael|Jacksson Now I want that each first name a...
VSTO: can't open another Excel file, while first file is blocked by modal window from Add-in
We can't open another Excel file, while first file is blocked by modal window from our Add-in. Closing the dialog window unfreezes all pending file opens. Excel version is 2007. Is there a programmatic work around, that would allow Microsoft Excel 2007 to open the second file in a separate window, while first window is waiting for the A...
Javascript Spreadsheet engine / library ? mapped to form fields
I'm looking into some sort of Javascript spreadsheet engine, that would allow me to define complex calculations in some sort of standard spreadsheet format (Excel, WKS or even some text based proprietary format) and then allow me to read it from this formatted file (on the server) into the Javascript spreadsheet engine and map it to par...
Query engine for a variable data source. C#
I have a growing set of Excel spreadsheets none with the same data structure. I need a mechanism to query each of these spreadsheets (DataTables) using a single interface. So essentially, you choose the DataTable from a dropdownlist and then perform your search. My initial thought was to handle it like this. Create a generic data str...
.NET & Excel Interop: Copying User Selection to Clipboard
Fairly straightforward scenario, for which I can't seem to find an answer anywhere: I am using a Microsoft WebBrowser ActiveX control (AxSHDocVw.AxWebBrowser) in a Windows Forms application. The WebBrowser control is used to display Excel workbooks in the application. I can obtain a reference to the internal document as a Microsoft.O...
How to concatenate in cell
I want to concatenate two or more cell but i don't want to concatenate whole cell .Only want to take 2 or more character of 1st cell and 2 or more character of 2nd cell then concatenate them in the 3rd cell.Like.. Student Name Serial number Address Group Section Student ID Monir 07001 Dhaka,Bangladesh Scienc...
vba code for excel - to encoding gibrish to hebrew
i have files that open with excel. when i open the file the text is like gibrish. i need to encode - tools-internet option - general-encode - hebrew iso-visual and then the file turn to hebrew there is a vba code that do that ? thanks, omri ...
Autogenerate Serial Number
I want to Auto generate serial number. Student Name Serial number Address Group Section Student ID Monir 07001 Dhaka,Bangladesh Science B SC001B When I enter a Student name it will automatically generate its Serial number in the place of Serial number .After that if i save it again enter any new student it will generate the next seri...
StreamWriter Response output - looks fine in Notepad but accents are garbage in Excel
Hi there, I'm using a technique from another stackoverflow question here, to write a CSV file to the Response output for a User to Open/Save. This is working fine and the file looks good in Notepad, but when I open it in Excel the accented characters are garbage. I assumed this was something to do with the character encoding, so tried m...
Rebase a 1-based array in c#
I have an array in c# that is 1-based (generated from a call to get_Value for an Excel Range I get a 2D array for example object[,] ExcelData = (object[,]) MySheet.UsedRange.get_Value(Excel.XlRangeValueDataType.xlRangeValueDefault); this appears as an array for example ExcelData[1..20,1..5] is there any way to tell the compiler to re...
VSTO merged cells
Is there any way in VSTO (/JET OLEDB or other methods of reading excel files) to tell if the data comes from a single cell or merged range of cells and get this range ? ...
Find the differences between 2 excel worksheets?
I have two excel files with the same format. They both have 1 column with data. One has 800 records and the other has 805 records, but I am not sure which of the 5 in the 805 set are not in the 800 set. Can I find this out using excel? ...