Search Results

Search found 4437 results on 178 pages for 'excel udf'.

Page 76/178 | < Previous Page | 72 73 74 75 76 77 78 79 80 81 82 83  | Next Page >

• SQL SERVER – Enable PowerPivot Plugin in Excel

  - by pinaldave

  Recently I had interesting experience at one conference. My PowerPivot plugin got disabled and I had no clue how to enable the same. After while, I figured out how to enable the same. Once I got back from the event, I searched online and realize that many other people online are facing the same problem. Here is how I solved the problem. When I…

  Read the article

• Convert each slide to PNG with LibreOffice Impress in terminal with excel graph

  - by Dean

  I need to convert each slide in a powerpoint presentation to a PNG with the command line. I have tried to convert it to a PDF then to individual PNGs but the images haven't exported properly. These images are graphs originally from Microsoft Excel. If I export it as a PNG from within LibreOffice the graph exports properly, but not if I convert…

  Read the article

• Developing an Interface to a Dynamic System

  - by radix07

  I work for a small company and have been designing a GUI to interface our embedded system. The problem with this embedded system is that it is not a finished product (may never be) and is constantly under development and being tweaked and updated for different customers and applications in small volumes. So to deal with this I made a…

  Read the article

• Moving Data From Excel to SQL Server - 10 Steps to Follow

  SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates the advantages of the graphical approach of SSIS. Andy Brown explains. Want to work faster with SQL Server?If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools…

  Read the article

• SSRS Reports as a Data Source in Excel 2013

  DBAs are expected to know how to administer the technologies that are available with and peripheral to SQL Server. To properly administer them, it certainly helps to understand the technology from the point of view of the user. By using an existing SSRS report as a data feed for Excel, Rodney Landrum explains how these users can now…

  Read the article

• How to create excel sheet data directly from the .net application?

  - by Girish

  I want to create excel sheet from asp.net application using C# language. please reply me how to create it and also if having source. I don't know how to create it. Also I want drop down list in one of column. how we can do this. Please reply me its urgent.... Regards, Girish

  Read the article

• Does Chrome always adds an XLS extension on a vnd.ms-excel mime type?

  - by Claudio

  It seems that a simple download of a PHP generated CSV file (with a vnd.ms-excel mime type for the sake of opening it with (Open)Office readly upon the "Save as..." dialog, when present) always gets the unwanted .xls extension when the UA is Google Chrome. The file would then be named as myfile.csv.xls. Firefox behaves correctly. I…

  Read the article

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

  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…

  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…

  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,…

  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,…

  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

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

  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 …

  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…

  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

< Previous Page | 72 73 74 75 76 77 78 79 80 81 82 83  | Next Page >