Search Results

Search found 4393 results on 176 pages for 'excel addins'.

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

• 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 to the value in…

  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 have to use REST in…

  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 installing Excel on the…

  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 there already any written…

  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 advance !

  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 do this?

  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 the "Cancel" button on File…

  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? Negative, I am a meat popsicle -…

  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

• how to export asp.net MVC detail view data to an excel file?

  - by sandeep

  how to export asp.net mvc view data to an excel file ? Actually my view page contain many viewdata types. i am using for each loop with these datatype to displaying data on the view page. my requirement is that i want to export this displayed data into excel file.how to do that? thanks

  Read the article

• How to open write reserved excel file in python with win32com?

  - by user261935

  Hello, I'm trying to open a write-protected ms excel 2007 file using win32com in python -- I know the password. I can open it with user input of the password into the excel dialog box. I want to be able to open the file without any user interaction. I've tried the following, but it still pops up the dialog box. …

  Read the article

• Why does Excel now give me already existing name range error on Copy Sheet?

  - by WilliamKF

  I've been working on a Microsoft Excel 2007 spreadsheet for several days. I'm working from a master template like sheet and copying it to a new sheet repeatedly. Up until today, this was happening with no issues. However, in the middle of today this suddenly changed and I do not know why. Now, whenever I try to…

  Read the article

• Demystified - BI in SharePoint 2010

  - by Sahil Malik

  Ad:: SharePoint 2007 Training in .NET 3.5 technologies (more information). Frequently, my clients ask me if there is a good guide on deciphering the seemingly daunting choice of products from Microsoft when it comes to business…

  Read the article

• Common request: export #Tabular model and data to #PowerPivot

  - by Marco Russo (SQLBI)

  I received this request in many courses, messages and also forum discussions: having an Analysis Services Tabular model, it would be nice being able to extract a correspondent PowerPivot data model. In order of priority, here are the specific feature people (including me) would like to see: Create an empty…

  Read the article

• Software solution from the 2000's, should I attempt to patch or remake the whole thing?

  - by ShadowScripter

  I was sent out to discuss a system that a certain company is currently using and what should be done with it. The company manufactures various carton displays. This system was developed to keep track of clients, orders and prices. Lots have happened since the system was created and the system is now, as the…

  Read the article

• XQuery fn:replace not behaving as expected

  - by CoolGravatar

  I have an Excel worksheet in XML format which contains <Cell ss:StyleID="s127"><Data ss:Type="String">A01-Replace</Data></Cell> I want to replace @A01-Replace with a different string. I'm using the XQuery's replace function like so: let $excel := doc("excel.xml") let $test :=…

  Read the article

• How to use Excel VBA to extract Memo field from Access Database?

  - by the.jxc

  I have an Excel spreadsheet. I am connecting to an Access database via ODBC. Something along then lines of: Set dbEng = CreateObject("DAO.DBEngine.40") Set oWspc = dbEng.CreateWorkspace("ODBCWspc", "", "", dbUseODBC) Set oConn = oWspc.OpenConnection("Connection", , True, "ODBC;DSN=CLIENTDB;") Then I…

  Read the article

• C# Convert Excel Range to Dataset or Datatable, etc.

  - by htbrady

  I have an Excel spreadsheet that will sit out on a network share drive. It needs to be accessed by my Winforms C# 3.0 application (many users could be using the app and hitting this spreadsheet at the same time). There is a lot of data on one worksheet. This data is broken out into areas that I have…

  Read the article

• Convert Excel Range to ADO.NET DataSet or DataTable, etc.

  - by htbrady

  I have an Excel spreadsheet that will sit out on a network share drive. It needs to be accessed by my Winforms C# 3.0 application (many users could be using the app and hitting this spreadsheet at the same time). There is a lot of data on one worksheet. This data is broken out into areas that I have…

  Read the article

• MS Excel automation without macros in the generated reports. Any thoughts?

  - by ezeki77

  Hello! I know that the web is full of questions like this one, but I still haven't been able to apply the answers I can find to my situation. I realize there is VBA, but I always disliked having the program/macro living inside the Excel file, with the resulting bloat, security warnings, etc. I'm…

  Read the article

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