Search Results

Search found 5640 results on 226 pages for 'excel automation'.

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

• 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

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

• 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

• 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

• 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

• Using a pre-existing function for a new row

  - by Jonathan Kushner

  I have an Excel document that contains X columns and N number of rows. The very last column of a row performs a SUM of the first X-1 columns. The problem I have is, the user of this Excel document progressively adds rows to the document, and because of this, the function does not exist yet in the last column for new rows. I need a way to have this function exist in new rows dynamically (the user is not Excel-savvy and doesn't have the ability to just drag the function down a row).

  Read the article

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