excel

excel: how do i sort within a cell?

i have a string separated by commas, is it possible to use an excel formula to sort within the values within the cell? ...

VBA: Using & inside of an equation

I want to make a formula with a & inside it but VBA thinks its a concatenate symbol ""&"" does not work, are there any other tricks? ...

Speed Up OpenXML retrieving values

I am using the example from http://msdn.microsoft.com/en-us/library/bb332058(v=office.12).aspx to retrieve values from an excel file. I am retrieving about 1500 values, and it is very slow. My question does anyone know a better way to retrieve values quickly out of an excel file? One thing that did save about 6 seconds was not opening...

Automatically adding rows to excel file template

Hi, I am running .net 4.0 asp.net app on IIS 7. I want to know if there is an easy way of adding rows to an excel 2007/2010 (not too fussed) template file that a user can download from the server. For example, the user might check a couple of tick boxes and clicks a button on the web page. The server does a sql query on a table and com...

How do i Export a DataTable to an *.xls file (excel) in C# Compact framework 3.5?

i have a table in a C# compact framework 3.5 application that i need to export to an excel that will be used on a regular desktop pc. i already wrote it to an XML successfully if that helps... but i need a .xls file please help... ...

dbsaint - Retrieve form EXCEL

How can i retrieve datas (using sql) from Excel to a table in Oracle database .I am using dbsaint. Insted of DBSAINT which developer tool shold i use for this purpose Thanks ...

Repository info (SVN) integration with Excel

Hello, i'm new to this kind of things. Kinda the first post ever regarding programming, since till now i managed to google everything that i needed. Thanks for your patience:) . About my problem/goal: On our project we will have to have some kind of documentation management control. We will have around 160 .docx files (all files are al...

Access to excel file in the server without installing excel

Hello, I've created a library to pass/get data to/from excel. To execute in my machine i modified the access permisions in COM+ console. The thing is that im interested in upload this component to my online server, but there i havent installed excel. Are there any way to register excel in COM+ without install excel? Thanks in adva...

DsoFramer disables running Excel instances

I'm using DsoFramer control to display Excel documents within my application. Here's the problem: if i have Excel 2007 running as a standalone application before launching my application, and then launch mine and open an Excel document within it, then standalone Excel becomes inaccessible (can't be alt+tabbed to) for as long as my applic...

Filling cells based on values in range

I need help writing a sub routine for my program in excel. What I am trying to do is take information from one sheet (Bar code master) and fill it in to another sheet(Template). I recorded a macro and that got me to the point of copying and pasting info. On the bar code master sheet I have the range of bar codes listed with the beginning...

Hide toolbars in a Excel open within SWT application

Hi, I am looking for a code snippet that hides excel all control bars and menus in an embedded excel sheet. Does somebody have anything like that? Regards, Wojtek ...

Freeze header on export to excel from SSRS

I have the header in my report on SSRS frozen so it scrolls down as I scroll down the page. Is it possible to keep this header frozen when I export the report to excel so it will do the same in excel? ...

Cross reference mailing lists in excel/access

I have two separate mailing lists. One is in excel and the other is in access. How can I cross reference these two lists to omit duplicates? ...

Client side Excel interop using Silverlight 4

I'm trying to see if it is possible to read an Excel spreadsheet on the client using Silverlight 4 and use Excel interop libraries to read the data. I've seen sample code such as: dynamic excel = AutomationFactory.CreateObject("Excel.Application") but how do I even know what is possible to do here if the dynamic keyword is used? ...

excel 2007 vba Application.Dialogs(xlDialogPrint).Show crashes if user chooses print preview

In Excel 2007, have a button that triggers a macro, which selects a few sheets out of many and sends to Application.Dialogs(xlDialogPrint).Show. As part of selecting the few sheets there are other macros triggered like showing certain rows, password protecting and unprotect-ing, etc. It prints and cancels fine, except when users click ...

Do we have any open source tool which allow generation of excel file from database table?

Do we have any open source tool which allow generation of excel file from database table? Actually we don't have comments in our database tables, I would be great if i can take the table def in excel file, update the comments and execute the scripts back in database. ...

QUERY ON DATES TO EXCEL USING C#

I was trying to make excel graphs using query in c# and I need to collect data for the last month. I am using the following code and its not giving any error but its not giving any result either. Basicaly I have the data in excel sheets and using that data im making graphs. First im geting the two dates and converting them to short str...

How to detect the print preview window of Excel 2003, with vb.net ?

Hi, I need to be able to test if the current view is print preview in Excel 2003. Is there something in the excel object model to simply access this property? (Like the application.printpreview in the Word object model...). Any advice would be more than welcome, Thanks Julien PS: Long story short, I'm developing a vsto addin with k...

Read columns names issue with reader.GetName and OLEDB Excel provider

Hi, I have an issue to retrieve the columns names in an Excel sheet. I have an Excel sheet with only 3 cells in the first row with these 3 values: in A1: A in B1: B in C1: A.B.C When I try to execute my method the label shows: A,B,A#B#C And not: A,B,A.B.C My Code: protected void btnExecute_Click(object sender, EventArgs...

How do I "Create a Reference To a Different Workbook" that supports closed workbooks.

I want to do something like this: Create a Reference To a Different Workbook (look for this section in the page). However, the instruction says that the documents must be opened for the INDIRECT function to work. How can I make it work even if the documents are closed? Any other solutions / alternatives? I don't want to open each file...