Search Results

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

Page 69/172 | < Previous Page | 65 66 67 68 69 70 71 72 73 74 75 76  | Next Page >

• Can you detect if and excel find and replace is active during worksheet_change()?

  - by John Griffiths

  Hi I've just crashed excel using amazon spreadsheet to update feed. When doing find and replace [replace all] with 2 cells selected after the first replacement the worksheet_change() function finished with the whole spreadsheet selected. This meant that the replacements took place outside of the original area. Unfortunatly the replcement text…

  Read the article

• Is there a way to hide a row or column in excel without using VBA?

  - by AJ

  I know of several approaches using a macro (VBA) to show/hide columns and rows in Excel, but I cannot figure out or find a way to do this using either a formula or conditional formatting. Of particular interest is Excel 2007 - but I'd be curious to know if someone has managed to do it in any version of Excel. For those who want background, I…

  Read the article

• how do i set a value to a range using a function from module in excel vba?

  - by gadym

  hello all, i want to do a simple function in a module in excel vba, so i can use it as a custom function in excel. (i use excel 2003, or 2007 , it's doesnt matter) i create a function(!) in a new workbook and it's looks like this: Function a() Sheets(1).Range("A1").Value = 4 end function but when i try to use it on the sheet1 it's wont…

  Read the article

• The Excel Column Name assigment problem

  - by Peter Larsson

  Here is a generic algorithm to get the Excel column name according to it's position. By changing the @Base parameter, you can do this for any sequence according to same style as Excel. DECLARE @Value INT = 8839,         @Base TINYINT = 26   ;WITH cteSequence(Value, Delta, Quote, Base, Chr) AS (…

  Read the article

• Cloudcel: Excel Meets the Cloud

  - by kaleidoscope

  Cloudscale  is launching Cloudcel Cloudcel is the first product that demonstrates the full power of integrated "Client-plus-Cloud" computing. You use desktop Excel in the normal way, but can also now seamlessly tap into the scalability and massive parallelism of the cloud, entirely from within Excel, to handle your Big…

  Read the article

• Export Gridview/Listview to Excel with Color formatting

  In this article, I explain how to export Gridview / Listview to excel with same color formatting using .net.

  Read the article

• Excel or Access: how to group several lines in a table and insert contents in columns? ("split column")

  - by Martin

  I have a table containing data of sold products (shown in the example on the left): Columns: Number of the order Product Name Attribute - specifies what is given in the following field "value", e. g. Customer Name or Product Variant Value - is the value of the Attribute Count - is the number of products of this variant sold in the order …

  Read the article

• Is there a way to have "default" or "placeholder" values in Excel?

  - by Iszi

  I've got a spreadsheet with cells that I want to be user-editable, but that I also want to have "default" or "placeholder" values in, whenever there is no user-entered data. There's a couple good use cases for this: Prevent formula errors, while providing reasonable assumptions when a user has not entered (or has deleted) their own…

  Read the article

• ms excel 2010 in windows xp - when open workbook the data is formatted differently than when i saved it

  - by Justin

  I haven't been able to find an answer to this. I have multiple files that I use regularly in excel that now have cell formats of "date". Every single cell in the entire workbook (all sheets) is now formatted as "date". The problem is that I lost my formatting for percents, numbers years, etc and now everything is converted to…

  Read the article

• Excel: How to treat multiple lines as one while sorting?

  - by crono

  I get a XLS-File as a database report. The File is in the following format: | Customer | Name | ... | Orders 1 | 6 | ... | ... | 1234 2 | | | | 4567 3 | | | | 8910 4 | 3 | ... | ... | 3210 5 | | | | 8765 6 | 1 | ... | ... | 1000 7 | |…

  Read the article

• Create bulk or mass folders using names from Excel spreadsheet with Visual Basic.Net

  This sample code tells you how to create a series of folders using folder names stored in an excel spreadsheet.

  Read the article

• Conditional formatting Excel 2007/2010: Highlight the first cell in the row that contains duplicate values?

  - by Nancy Prades

  I have a table with hundreds of columns and rows of data; each row and column have a header. For instance, column headers are ITEM, FILE1, FILE2, FILE3, etc. and row headers are AA, BB, CC, DD, and so on. Under conditional formatting, I used "Highlight Cells Rules" "Equal to", in order to highlight cells that have values equal…

  Read the article

• Accessing Excel Databases using ADO.NET

  In this article I will explain about Accessing Excel Databases using ADO.NET.

  Read the article

• export google search results to excel [closed]

  - by Om23

  I want to make a program/script that will be able to take the data from the excel spreadsheet in column A (for example, "team 123") and search Google and take the first 3 results from Google and put the data into the excel spreadsheet. I don't have that much experience in programming. So what language should I use? I know I…

  Read the article

• Is there a C# library that will perform the Excel NORMINV function?

  - by Portman

  I'm running some Monte Carlo simulations and making extensive use of the Excel function NORM.INV using Office Interrop. This functions takes three arguments (probability, average, standard deviation) and returns the inverse of the cumulative distribution. I'd like to move my code into a web app, but that will require…

  Read the article

• Is there a way to add more than one hyperlink in an excel cell in vb.net?

  - by Varun Mahajan

  I have an excel sheet where one column consist of comma seprated hyperlinks. However, I am unable to see a way to insert more that one hyperlinks in an excel cell. Is there a workaeround this?

  Read the article

• Is there a code-generator to create DataTable definition block from Excel Work sheet?

  - by burak ozdogan

  Hi, Basically the thing I want to achieve is to have a data-table that I want to use in my unit tests. And when I run my unit tests, I do not want to read any excel file into a data-table -or any call to Db-. So, I would like to have method that returns a data-table with the values that I can use in my test. Is…

  Read the article

• Datatype to save excel file in sql server?

  - by gowri-ganapathy

  Hi, I have a table in which there are two columns : 1. import type, 2. Excel import template. The second column - "Excel import template" should store the whole excel file. How would I save excel file in databse...can I use binary datatype column, convert excel file to bytes and save the same ? Thanks in…

  Read the article

• How can I generate a flat excel file from a .rdl report?

  - by NotDan

  I have a .rdl report that formats data as a report. I want to export that data to excel as a flat table with the raw data that was returned based on the params in the report. The default excel export looks just like the report which isn't what I want (I just want rows and columns). Is there an easy way to…

  Read the article

• How do I add a collection hyperlinks in a specific cell or column of an Excel spreadsheet programmat

  - by Girish

  I am using functionality that creates an Excel spreadsheet in my application. It is achieved using the ExcelPackage DLL or the Microsoft Excel COM DLL. I want something to hold hyperlink collections in a cell. Is there is any way to achieve this?

  Read the article

• ASP.Net export to excel + File Download dialog action.

  - by Muhammad Umar Siddique

  i m trying to export data from asp.net form to excel using following lines of code Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("content-disposition", "attachment; filename=Report.xls"); Everything seems to be working fine. Now what I need it to take some action if user clicks…

  Read the article

• How do I add a form in an Excel sheet?

  - by Raj Kumar

  How can I add an input form in an Excel sheet. I want to insert values into an Excel cell using the form.

  Read the article

• How can I perform a reverse string search in Excel without using VBA?

  - by e.James

  I have an Excel spreadsheet containing a list of strings. Each string is made up of several words, but the number of words in each string is different. Using built in Excel functions (no VBA), is there a way to isolate the last word in each string? Examples: Are you classified as human? - human?…

  Read the article

• How to get the current open documents in Excel using C#?

  - by Joan Venge

  All I need is to get the list of currently open documents in the currently open instance of Microsoft Excel. But I don't know Excel terminology to know if these documents are called workbooks, or sheets, or windows, etc. Any ideas

  Read the article

• Parcing formula to put in to excel cell using C# and SpreadSheetGear?

  - by Avinash

  Hey can any body suggest that how to store excel formula as string, and parse this formula in c# to put it in to dynamically created excel sheet.

  Read the article

< Previous Page | 65 66 67 68 69 70 71 72 73 74 75 76  | Next Page >