Search Results

Search found 5148 results on 206 pages for 'excel macro'.

Page 80/206 | < Previous Page | 76 77 78 79 80 81 82 83 84 85 86 87  | Next Page >

• How do I programmatically create Excel row groups with the +/- box at the top of the group, not bott

  - by Alex

  I am creating an Excel sheet programmatically. I like to show group totals above each group, and for this to look best the +/- sign that opens and closes the rows should be at the top, where the total row is. Is there a way to accomplish this? TIA, Alex

  Read the article

• How to format a datetime so that Excel will understand it?

  - by nickf

  I have a script which outputs a CSV file. How should I format dates or date+time fields so that Excel will correctly parse that field as a date?

  Read the article

• C++ Builder and Excel Automation, where to get started?

  - by WindsurferOak

  I want to dynamically create and populate an excel spreadsheet with C++ builder 2009, but I'm not entirely sure how to go about it. Searching the web, I've narrowed it down to using OLE Automation. Moreover, I'm looking for a document or programming tutorial that can get me started. Is there a simple programming tutorial that also thoroughly explains the concepts of OLE automation?

  Read the article

• transfer data from Excel to SQL Server

  - by Jason

  I have an Excel Spreadsheet that contains all my data that I need to put into an SQL Server database. I am fairly new o ASP.NET and have never had to export from Excel to SQL Server before. My Excel spreadsheets looks like this Trade Heading - ArtID - BusinessName - AdStyleCode - Address - Suburb In SQL Server I have created a table named "Listings" which is in this format intListingID - intCategoryID - BusinessName - ArtID - intAdCode -Address - Suburb What would be the best way to export the data from Excel and then import it into SQLServer 2005. Thanks...

  Read the article

• Exporting each Excel column to individual text or csv files?

  - by powerofgrayskull

  I have an Excel worksheet with around 100 cols. Does anyone know of an easy way to write the contents of each column to a csv or txt file?

  Read the article

• where can I find a good ruby excel parser that also had good documentation?

  - by Chris Drappier

  Hi All, I've spent some time today looking for a pure ruby library that will parse an excel workbook. I could find the parseexcel gem in the repos, but the problem is that I can't find any documentation on it. and the rdoc is pitiful. so, my question is 1) is there good documentation out there for this gem? 2) if not, is there another gem that does the same thing that has good documentation? thx :) -C

  Read the article

• How do I show an embedded excel file in a WebPage?

  - by Juan Manuel Formoso

  I want to allow an Excel report to be viewed embedded in a WebPage... is there a way? I don't want to use an ActiveX, or OWC (Office Web Components), I just want to open an existing file from the internet explorer application. I don't want users to download and then open it. Using an iframe wouldn't be a problem, but my preliminary tests weren't successful Any ideas? Is it at all possible?

  Read the article

• Is it possible to write an Addin that works in both Excel 2003 and 2007?

  - by user169867

  I've been writing a shared addin for Excel 2003. It adds a menu (CommandBarPopup) and a couple menu items off it (CommandBarButton) that when clicked open a WPF window to read a couple values and manipulate the worksheet. Is there a way to write it so that it would work in office 2007/2010 as well, or is it impossible? If so, can anyone provide instructions for how that is done?

  Read the article

• How to use jet engine to read data from excel in vb.

  - by Jason

  Hi all, how can I create a connection to excel file and view the result in vb. I am using visual studio 2008, I have been trying to look for answers around but could not find one that teaches step by step.And what references do I need to use? Thanks in advance. Regards Jason

  Read the article

• Need VB code to paste an data retrived during runtime in QTP scipt in an column of an excel sheet.

  - by Sweety

  I am running a QTP script where a data is produced dynamically.I am retriving the data during runtime and then I need to paste that data in an excel sheet (in an column).Please suggest how to code it. Thanks for any help.

  Read the article

• how can i get data from excel via "select statement" in sql 2005?

  - by Phsika

  is there any method to get data from excel to sql ? i think that we can do without any writing C#codes. For example : select * from MyExcellFile.xls.Sheet1. Or may be any wizard in sql?

  Read the article

• how to make a frequency function in matlab like the excel frequency function?

  - by Ben Fossen

  I have a list that is sorted and I want to know how many values are in each bin? I made bins using linspace(floor(fist_element_list), ceil(last_element_list), num_bins) Is there a built in function or an easy way to do this in Matlab? All I can think of is doing it manually. I would like a frequency function like the one in excel.

  Read the article

• how to call the chart in excel using poi method?

  - by Zen

  i have an excel template and there was a chart there, I was confuse on how can I call that chart when I'm coding in vb.net.. Can anyone help me on how can I call the chart for me to set the new value to fill the chart.. It is possible to call?

  Read the article

• PHP Excel - Correct format for strings / numbers beginning with zero?

  - by Dan

  Hi, I'm trying to use PHP to create a file containing a list of phone numbers. It's working OK however if the phone number begins with zero, the digit is dropped from the excel file. Does anyone know how to set the formatting correctly so that it remains in place? Any advice appreciated. Thanks.

  Read the article

• How to generate a cell click event in Excel 2007 VSTO with VB?

  - by Kevin Boyd

  Well I have browsed through Application events in Excel 2007 however I can't find any event generated on a cell click. I can't use a double click event at the moment due to application constraints. Is there a way I can create a custom click event and attach it to a sheet for generating a cell click event.

  Read the article

• Multiple footer rows in a column of worksheet in excel.

  - by niveditha

  I need to have three rows within the footer section of a column while generating an excel worksheet... I wrote a code as follows I expected the output to be : Header cell 1 Footer 1 Footer 2 Footer 3 But I get the output as: Header cell 1 Footer 3 Please help me with this issue. Thank You in advance.

  Read the article

• Export Data to Excel without Server-side install

  - by user203127

  Hi, I want to export my data from grid view to the excel. Unfortunately i came to know that there is no excel software on server side. Is there any way that i can still export data in excel format without having excel software on server side. Thanks.

  Read the article

• How can I read only first row from an Excel file with OleDbDataAdapter?

  - by user330564

  Hi all. Can anybody help me? How can I read only first row from an Excel file with OleDbDataAdapter? I know how I can read all data from any spread sheet: var dataAdapter = new OleDbDataAdapter("SELECT * FROM [" + sheetName + "$]", oledbConnection); But I don't know how can I do this for one row.

  Read the article

• How can I display the MDX generated by Excel 2007 when using a pivot table?

  - by Espo

  Pretty much what the title says. Is it possible to show the MDX that is sent to OLAP source when using a pivot table in Excel 2007?

  Read the article

• How to get data from excel sheet in a loop using jquery?

  - by Uday

  I am trying to get data from excel to jquery loop? Can someone help me on this?

  Read the article

• Is there any simple way to convert .xls file to .csv file? (Excel)

  - by Gold

  Hi Is there any simple way to convert .xls file to .csv file ? (Excel) in C# code ? Thanks in advance

  Read the article

• How to automate a web query login to download data in Microsoft Excel 2007?

  - by Wei84

  Hi, Have anyone can sharing with me the info on which is how to automate a web query login to download data in Ms.Excel 2007? Problem is existing that i need to manually login through a web query each time.... Thanks in advance for any help you can provide!

  Read the article

• Excel / VB - How do I loop through each row/column and do formatting based on the value?

  - by Johnny 5

  Here's what I need to do: 1) Loop through every cell in a worksheet 2) Make formatting changes (bold, etc) to fields relative to each field based on the value What I mean is that if a field has a value of "foo", I want to make the field that is (-1, -3) from it bold, etc. I tried to do this with the following script with no luck. Thanks Johnny Pseudo Code to Explain: For Each Cell in WorkSheet If Value of Cell is 'Subtotal' Make the cell 2 cells to the left and 1 cell up from here bold and underlined End If End ForEach The Failed Macro (I don't really know VB at all): Sub Macro2() ' ' ' Dim rnArea As Range Dim rnCell As Range Set rnArea = Range("J1:J2000") For Each rnCell In rnArea With rnCell If Not IsError(rnCell.Value) Then Select Case .Value Case "000 Total" ActiveCell.Offset(-1, -3).Select ActiveCell.Font.Underline = XlUnderlineStyle.xlUnderlineStyleSingleAccounting End Select End If End With Next End Sub

  Read the article

• using Excel VBA, given the daily price of 50 stocks, choose 10 stocks such that they have the minumu

  - by correl

  The high-level goal is to choose 10 stocks that have the lowest correlation among one another, out of a pool of 50, so that I can have a well-diversified portfolio. I have managed to write some VBA macro to download the past 3 years of daily price data from Yahoo finance, and then compute the 50x50 correlation matrix (using the Correl function), using the daily close as the data. What I have tried so far is just some local-maximum heuristic: - For the two stocks that have the highest correlation with each other, remove one of them. Between the two, remove the one that has the higher average correlation with all the other stocks. - When I remove a stock from the pool, I just delete the correponding row and column, to give a smaller matrix. - Repeat until I have just 10 stocks remaining (a 10x10 matrix). I was wondering if there is some algorithm that already solves such a problem and gives the optimum solution?

  Read the article

• sharepoint cannot export all fields to spreadsheet

  - by Colin Dekker

  I am trying to make an export of a list in SharePoint to an Excel spreadsheet. I have added all needed fields to my default view of the list, (like Publishing Start Date / End date) but some fields (like Publishing Start Date / End date) don't show up in Excel. Any idea? EDIT: My setup is a MOSS standard edition, the needed fields (Publishing Start Date / End date) are standard SharePoint publishing fields. The versions of Excel I tried it with are 2003 and 2007

  Read the article

< Previous Page | 76 77 78 79 80 81 82 83 84 85 86 87  | Next Page >