Search Results

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

Page 30/172 | < Previous Page | 26 27 28 29 30 31 32 33 34 35 36 37  | Next Page >

• Obtaining Excel worksheet reference by worksheet name via C#

  - by Chapax

  Hi, I'm currently obtaining a handle to a Excel worksheet by using the below C# code: *Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(15);//Get the worksheet "SubSignOff" number* Is there any way that I can obtain the same by using the worksheet name -- "SubSignOff" ? Many thanks for your help. --Chapax

  Read the article

• How can I Create an Excel Sheet with Microsoft.Office.Interop.Excel.dll?

  - by Girish

  How can I create an Excel sheet with Microsoft.Office.Interop.Excel.dll in ASP.NET?

  Read the article

• Exporting gridview to excel with combo,checkbox type columns + winforms

  - by Royson

  Hi, I want to export grid view data to excel file in windows forms application. I tried one solution but it fails to export combo box type column to excel. Excel file should have combo box, check box columns. Thanks..

  Read the article

• How to create validation from name range on another worksheet in excel using C#?

  - by Ekkapop

  I have create name range on sheet "A" so I need to use this range as validation ComboBox on sheet B. I want to know how can I do that?

  Read the article

• Reading Excel Cells using C#

  - by kapil

  What's the way to open a excel workbook and to read excel cells?

  Read the article

• ASP.NET Excel Export formatting question

  - by BWC

  Hey Guys, I've been banging my head on the wall over this issue for a couple days now and I need some help. I'm creating an excel file using ASP.net and everything is going just fine except one column has to be formatted as a decimal to 2 places but when it pulls into excel, excel automatically formats it as a whole number instead of keeping the…

  Read the article

• Hyperlinks in Excel generated in java

  - by cedar715

  I've to create hyperlinks in Excel as above. On click of the hyperlink, the data should be populated somewhere down the excel. Am using Apache POI to generate the excel. is it possible with POI or other tools to generate such hyperlinks.

  Read the article

• sp_addlinkedserver procedure not linking Excel source

  - by brohjoe

  I am attempting to link an Excel source to a SQL Server DB on the Go Daddy website.  When I execute the sp in SQL Server, it shows it executed successfully, but no data is linked. This is the main part of my procedure:      EXEC sp_addlinkedserver @server = 'XLHybrid', @provider = 'Microsoft.ACE.OLEDB.12.0',…

  Read the article

• Creating an Excel file using .NET (C#) - Problems with columns headers!

  - by tsocks

  Hello, I want to create & fill a .xls file using ADO.NET or LINQ, but I do not want to have the columns names in the first row. I just want to insert rows starting in row no. 1. I know I have to insert colums first, but... is there a way to 'hide' those columns headers? The problem is that, in first row of my spreadsheet, I must…

  Read the article

• Opening a huge .csv file with Excel Interop using C#

  - by user262102

  Hi, I have an application that write huge .csv files about the size ranging from 1 GB to 2 GB. I need to color code the file and save it as .xlsx. So I have tried using Excel Interop and it works great for small files, but when I try to open a 1.3 GB .csv file with Excel, I get an Hresult error. Any ideas as to how I could…

  Read the article

• Excel ODBC and 64 bit server

  - by Causas

  using ASP.NET I need to update an excel template. Our server is running Windows 2008 in 64 bit mode. I am using the following code to access the excel file: ... string connection = @"Provider=MSDASQL;Driver={Microsoft Excel Driver (*.xls)};DBQ=" + path + ";"; ... IF the application pool is set to Enable 32 bit…

  Read the article

• Cannot loop through Excel 2003 files in SSIS 2008

  - by Techspirit

  Hi, I am trying to execute a SSIS 2008 package on a 64-bit OS and import Excel 2003 files to SQL Server 2008. I have created an OLEDB Connection to the Excel file with a Connection String that retrieves the Excel file from a variable, inside the ForEach Loop Container. The Run64BitRunTime is set to false. I am not able to…

  Read the article

• Excel 2010 64 bit can't create .net object

  - by aboes81

  I have a simple class library that I use in Excel. Here is a simplification of my class... using System; using System.Runtime.InteropServices; namespace SimpleLibrary { [ComVisible(true)] public interface ISixGenerator { int Six(); } public class SixGenerator : ISixGenerator { public int Six() { return 6;…

  Read the article

• Open an Access database and run one of its Macros from Excel

  - by sqlnoob

  From Excel, I need to open an Access database and run one of the database's macros. I'm using Excel and Access 2007. Here is my code in Excel: Sub accessMacro() Dim appAccess As New Access.Application Set appAccess = Access.Application appAccess.OpenCurrentDatabase "C:\blah.mdb" appAccess.Visible = True …

  Read the article

• How to read more than 256 columns from an excel file (2007 format) using OLEDB

  - by Nan T

  I'm trying to import a excel file with more than 256 columns using OLEDB in C#. I tried all kinds of things, but it doesn't seem to be possible to read more than 256 columns from a excel (2007 format) file. I'm wondering if it's a bug or I'm simply missing something. Here is the connection string I used: …

  Read the article

• Changing a datatype solely for the purpose of Excel Export in Crystal Reports

  - by yeahumok

  I have a report that has several numerical fields. To fill a project requirement, i had to use the following formula: if {DataTable1.No of Investments}>9999 then '*****' else toText({DataTable1.No of Investments},0) Basically, if the number fed in is bigger than 9999 it turns into * on the report.…

  Read the article

• C# Excel Exception

  - by Andrew James Watt

  I am trying to copy all data from worksheet1 and paste the values into worksheet2 at the same position I am using office 2003 and the Interlop library. Here is my code; public void CreateExcelWorksheet() { Microsoft.Office.Interop.Excel.Application xlApp = new…

  Read the article

• Referencing Excel Sheets with JET Driver Sheets Are Duplicated with Underscores

  - by MasterMax1313

  I'm referencing an excel document with the JET database driver, which was working just fine until one day the application failed. Upon further investigation I noticed that the tabs were duplicated in some instances (all tabs actually) - i.e. Tab1$ and Tab1$_. I've researched this…

  Read the article

• Create Excel files from C# without office

  - by tbischel

  I am writing a program that generates excel reports, currently using the Microsoft.Interop.Excel reference. My dev computer has Excel on it, but the end user may or may not have Office installed. Will this tool fail if Office isn't installed on the end users computer, or is…

  Read the article

• ADOMD & Excel Integration

  - by koumides

  All, We have an Excel spreadsheet that uses ADOMD to query OLAP cubes and present the data in Excel. We are using version 2.8 at the moment of the ADOMD API. As far as I know there is an ADOMD.NET API for querying OLAP cubes. Can this new .NET version used from inside Excel…

  Read the article

• Problem with writing a file to excel with spreadsheet

  - by winter sun

  I am trying to write excel file by using ruby 1.9 spreadsheet version 0.6.4.1 on windows. Everything is going ok, until I get to the book.write statement when I write book.write "c:/spreadsheet/excel-file.xls I keep getting the following error No such file or directory -…

  Read the article

• How to get named excel sheets while exporting from SSRS

  - by rao

  Whenever a single page report is exported to excel, sheet in excel is named by the report name. If a report has multiple pages, the sheets are named as sheet1, sheet2,.... Is there any way to specify sheet names in SSRS 2005 ? solution: Found this after some googleing:…

  Read the article

• Using excel import wizard through code?

  - by baron

  I am creating a Generate Report button for some data in my application. The report will just generate a CSV file, which I then automatically launch in excel. Problem is with one of the data fields, is text and has leading zeroes (which I need to keep). When the file is…

  Read the article

• Excel Spreadsheet - Best way to perform an Oracle Query on a cell

  - by Jamie

  Hi there, I have an Excel Spreadsheeet. There is a cell containing a concatenated name and surname (don't ask why), for example: Cell A2 BLOGGSJOE On this cell, I would like to run the following SQL and output it to cell A3, A4 and A5 SELECT i.id, i.forename,…

  Read the article

• Copy recordset data into multiple sheets to avoid problem of maximum rows limit in Excel VBA

  - by Sam

  I am developing reporting application in Excel/vba 2003. VBA code sends search query to database and gets the data through recordset. It will then be copied to one of excel sheet. The rertrieved data looks like as shown below. …

  Read the article

< Previous Page | 26 27 28 29 30 31 32 33 34 35 36 37  | Next Page >