Search Results

Search found 6232 results on 250 pages for 'excel 2013'.

Page 100/250 | < Previous Page | 96 97 98 99 100 101 102 103 104 105 106 107  | Next Page >

• 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 to get the list of Function and Sub of a given module name in Excel VBA

  - by Kratz

  I am working on a helper macro that look into the list function on a given module name on the active excel workbook. Ex: I have a module name "Module1". Inside this module has the following function or sub Sub Sub1() End Sub Sub Sub2() End Sub Function Func1() End Function Function Func2() End Function Is there a command or routine that can return the list of Function and Sub names?

  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

• 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

• 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

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

• 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

• How can I convert Excel VBA to Google spreadsheets Javascript API?

  - by Bearjcc

  I have recorded a macro in Excel, but I want to run this code in Google spreadsheets. I do not know how to program in either code. How do I convert them? I tried an online VB to Javascript converter, but this does not work with VBA.

  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

< Previous Page | 96 97 98 99 100 101 102 103 104 105 106 107  | Next Page >