Search Results

Search found 4288 results on 172 pages for 'excel'.

Page 45/172 | < Previous Page | 41 42 43 44 45 46 47 48 49 50 51 52  | Next Page >

• How to Create VBA Add-In with Shared Codes for All Excels?

  - by StanFish

  I'm writing VBA codes for multiple Excel spreadsheets, which will be shared with others from time to time. At some point I find there are lots of duplications in my works. So I want to find a way to share codes in a sort of Excel add-in, like the .xla file. But when I tried to save the Excel file containing shared codes as .xla file, I got some…

  Read the article

• OpenXML SDK: Make Excel recalculate formula

  - by chiccodoro

  I update some cells of an Excel spreadsheet through the Microsoft Office OpenXML SDK 2.0. Changing the values makes all cells containing formula that depend on the changed cells invalid. However, due to the cached values Excel does not recalculate the formular, even if the user clicks on "Calculate now". What is the best way to invalidate all…

  Read the article

• phpexcel write excel and save ?

  - by boss

  code: <?php /** PHPExcel */ require_once '../Classes/PHPExcel.php'; /** PHPExcel_IOFactory */ require_once '../Classes/PHPExcel/IOFactory.php'; // Create new PHPExcel object $objPHPExcel = new PHPExcel(); // Set properties $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") …

  Read the article

• Passing an array argument from Excel VBA to a WCF service

  - by PrgTrdr

  I'm trying to pass an array as an argument to my WCF service. To test this using Damian's sample code, I modified GetData it to try to pass an array of ints instead of a single int as an argument: using System; using System.ServiceModel; namespace WcfService1 { [ServiceContract] public interface IService1 { …

  Read the article

• Upload An Excel File in Classic ASP On Windows 2003 x64 Using Office 2010 Drivers

  - by alphadogg

  So, we are migrating an old web app from a 32-bit server to a newer 64-bit server. The app is basically a Classic ASP app. The pool is set to run in 64-bit and cannot be set to 32-bit due to other components. However, this breaks the old usage of Jet drivers and subsequent parsing of Excel files. After some research, I…

  Read the article

• Implementing Excel 2003 COM Add-in UDF in Asyc Programming model using C#(VS 2005)

  - by Venu

  Hi: I am trying to implement a UDF using Excel COM Add-in(2003) with Visual Studio 2005 in C#. I would like to implement the UDF using async programming. The UDF is a slow operation as its results are fetched from a server. As an illustration(not a real world example),the following UDF works fine without any issue: …

  Read the article

• Powerpoint displays a "can't start the application" error when an Excel Chart object is embedded in

  - by A9S6

  This is a very common problem when Excel Worksheet or Chart is embedded into Word or Powerpoint. I am seeing this problem in both Word and Powerpoint and the reason it seems is the COM addin attached to Excel. The COM addin is written in C# (.NET). See the attached images for error dialogs. I debugged the addin and…

  Read the article

• deep linking in Excel sheets exported to html

  - by pomarc

  hello everybody, I am working on a project where I must export to html a lot of Excel files. This is pretty straightforward using automation and saving as html. The problem is that many of these sheets have links to worksheets of some other files. I must find a way to write a link to a single inner worksheet. …

  Read the article

• Excel automation using C#

  - by tecnodude

  Hi, I have a folder with close to 400 excel files. I need to copy the worksheets in all these excel files to a single excel file. using Interop and Reflection namespaces heres is what I have accomplished so far. I use folderBrowserDialog to browse to the folder and select it, this enable me to get the file…

  Read the article

• error while reading Excel sheet

  - by Lalit

  Hi, I have code to read Excel from c3 language : DataTable dtChildrenData = new DataTable(); OdbcConnection oConn = null; try { if (File.Exists(strSheetPath)) { oConn = new OdbcConnection(); …

  Read the article

• Export GridView to Excel (not working)

  - by Chiramisu

  I've spent the last two days trying to get some bloody data to export to Excel. After much research I determined that the best and most common way is using HttpResponse headers as shown in my code below. After stepping through countless times in debug mode, I have confirmed that the data is in fact…

  Read the article

• Best way reading from dirty excel sheets

  - by Ten Ton Gorilla

  I have to manipulate some Excel documents with C#. It's a batch process with no user interaction. It's going to parse data into a database, then output nice reports. The data is very dirty and cannot be ready using ADO. The data is nowhere near a nice table format. Best is defined as the…

  Read the article

• SQLAuthority News – Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010

  - by pinaldave

  Microsoft has really and truly created some buzz for PowerPivot. I have been asked to show the demo of Powerpivot in recent time even when I am doing relational database training. Attached is the few details where everyone can download PowerPivot and use the same. Microsoft SQL Server 2008 R2 –…

  Read the article

• Delphi 7 and Excel 2007 Open File Error

  - by Traci

  I am having difficulty opening a EXCEL 2007 in Delphi 7 It works for Office 2003 and below but the wonderful people at microsoft have sent an update or something and the delphi app fell over just earlier this month. oE := GetActiveOleObject('Excel.Application'); …

  Read the article

• Replace or recode several different values by a single value in an Excel file

  - by Ali

  Hi all, I have an Excel worksheet which contains data in several columns. For a specific column, I will need Excel to replace all values between, say 10 to 15, by the value 1 and values between 16 and 20 by the value 2 and so forth. I know how to do it for a single…

  Read the article

• Importing Excel to SQLCE

  - by ohadsc

  I have a table in excel format (2007 but I can save as anything below that, naturally), and I have an SQL Compact Edition 3.5 SP1 Database table with corresponding columns. I simply want to populate the SQLCE table with the data from the excel file. The data consists…

  Read the article

• Autofilter with multi-columns in Excel VBA

  - by tlpd

  I need to use VBA to filter some information in excel. As I have an excel with 20 columns, now want to use AutoFilter function to search in some columns if it contains one value (Ex: ID010). what i want is it'll display all rows that have at least one column contains…

  Read the article

• a question on using Microsoft Excel to do data analysis

  - by Gemma

  Hello everyone there, Me and my mates have been given an Excel spreasheet,which contains the data of the Census report. The column here corresponds to "Year" (from 2000-2010),the row means "City/Town",the cell is simply the population of a town at a particular year.…

  Read the article

• Calling oracle stored procedure from Excel - VBA

  - by Ram

  I have to execute an Oracle stored procedure from vba (Excel) with around 38 input parameters. The stored procedure will insert some values in the destination table once that is executed. When it is executed through VBA the number of fields which is…

  Read the article

• Use SSIS to populate Excel workbook generated using OOXML

  - by Maulik

  We are trying to generate MS Excel workbook using OOXML and populate data using SSIS. We are able to generate Workbook and sheets, also able to create columns and insert data in Header cell. We can also populate data using SSIS. But the Sheet…

  Read the article

• Adding filter to Excel sheet columns using SpreadsheetGear?

  - by Avinash

  How to add filter to excel work sheet columns using SpreadsheetGear?

  Read the article

• Data validation in excel cell using SpreadSheetGear.

  - by Avinash

  Hey How to validate integer and float in excel using spreadsheet gear. Thanks in Advance Avinash

  Read the article

• Problem with format a single excel column with OLE automation using Delphi

  - by Snackmoore

  Dear All, I have piece of code which I use to format a range of cells in Excel. It works fine in Excel 2007 but when the range is only 1 column wide and it is Excel 2003 instead of 2007, I'll get an error saying the I am assigning invalid…

  Read the article

• dump mdx query resultset into Excel

  - by sagar

  Hi I was just wondering if anybody knows how to dump mdx query result set into excel. Thanks, Sagar

  Read the article

• Excel and pgSQL

  - by running4surival

  How do I import data from a excel sheet onto a PGSQL database on linux?

  Read the article

< Previous Page | 41 42 43 44 45 46 47 48 49 50 51 52  | Next Page >