Search Results

Search found 6455 results on 259 pages for 'excel vba guy'.

Page 90/259 | < Previous Page | 86 87 88 89 90 91 92 93 94 95 96 97  | Next Page >

• How do you add a forms controls to a cell in a Excel spreadsheet for each row.

  - by Vecdid

  How do i add a forms control in excel to a cell, I know I can draw it, but I need to make it a member of each row and it's values attached to that cell/row.

  Read the article

• Why do multiline cells in my CSV file appear with a question mark at the end of each line in Excel?

  - by Chris Lindsay

  I'm currently working on a project where we'd like to allow a user to export their data to CSV. Some of the data we present has multiple values for a single cell, and so we use the standard CSV method of putting each value on its own line: Column A, Column B, Column C Value A, "Value B1 Value B2", Value C Most of the time this works fine, but some people are reporting seeing a small question mark in a box character appear at the end of each line when they load the file in Excel. Why is this happening?

  Read the article

• 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

• 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

• 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

• 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

• 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

• 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 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

• 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 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

• 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

• Excel macro, to copy and paste a cell value based on another cell value?

  - by Keziah Dorman

  Hi I shall try to explain clearly what I need to be able to do, here goes: I have an Excel spread sheet 1 with postcodes in column a and a number in column b. I need to create a macro/formula so that it will see the number (i.e 4) and copy and paste the postcode that number of times into sheet 2 column a underneath each other. I need to do this for the next row down etc until it comes to a blank. Sheet 1 A,B DE43PP,3 DE43PQ,8 Sheet 2 A,B DE43PP, DE43PP, DE43PP, Thanks

  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

• 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 | 86 87 88 89 90 91 92 93 94 95 96 97  | Next Page >