Jump to content

Search the Community

Showing results for tags 'excel'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Software & Hardware Discussions
    • LabVIEW Community Edition
    • LabVIEW General
    • LabVIEW (By Category)
    • Hardware
  • Resources
    • LabVIEW Getting Started
    • GCentral
    • Code Repository (Certified)
    • LAVA Code on LabVIEW Tools Network
    • Code In-Development
    • OpenG
  • Community
    • LAVA Lounge
    • LabVIEW Feedback for NI
    • LabVIEW Ecosystem
  • LAVA Site Related
    • Site Feedback & Support
    • Wiki Help

Categories

  • *Uncertified*
  • LabVIEW Tools Network Certified
  • LabVIEW API
    • VI Scripting
    • JKI Right-Click Framework Plugins
    • Quick Drop Plugins
    • XNodes
  • General
  • User Interface
    • X-Controls
  • LabVIEW IDE
    • Custom Probes
  • LabVIEW OOP
  • Database & File IO
  • Machine Vision & Imaging
  • Remote Control, Monitoring and the Internet
  • Hardware

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Personal Website


Company Website


Twitter Name


LinkedIn Profile


Facebook Page


Location


Interests

Found 14 results

  1. My project involves designing a front end for a synchronous generator using LabVIEW. It is actually data acquisition and display of signals in a file. The problem I face when building a program is that: 1)the sampling rate is set to 100 samples with 1 kHz sampling frequency.These signals are generated by daq assistant and i have used merge signals to merge these signals from daq assistant as well as signals from other radio buttons and Boolean as well. The problem is that when written on a file I am able to see only one instance of Boolean status for every 10
  2. Hello, Is it possble to put signatureline into excel footer using Active X ?
  3. Hi All, I am a new user to LabView and this is my first project using it. The project requires me to read a massive spreadsheet from Excel into LabView and then allowing the user to do the following: - Select which columns to plot against the first column - Use a cursor to select a portion of the spreadsheet: the Vi will then average the selected data by column (in other words, if the user selects data across multiple columns, the program will average data in each column separately). Then write the averages to the csv file. So far, I have the spreadsheet read into a table a
  4. Hello world! I am having a very strange issue controlling MS Excel through ActiveX from LabVIEW. I feel like it is likely not a rare task yet I find little to no helpful documentation from the MS side or NI side :/ I am a CLD and am working this project with a CLA and it has cost us over 40 hours of painstaking troubleshooting so far! I hope you can help. Here it goes... I am using the following setup: Windows 7 Pro LabVIEW 2015 SP1 Office 2016 I have created a simple LV class to create excel reports which works without an issue on my computer. The problem occur
  5. Now that it looks like Microsoft deprecated ActveX Automation interface in Excel 2016, the only other interface left is .NET interop assemblies. I have tried to reproduce Excel - Write Table.vi using .NET instead of ActiveX. The result of the effort is attached. There is a big problem though: The Range.value2 property could take 'anything' without a problem when using ActiveX (it was taking any variant)! But now it wants a .NET object. And the 'To .NET Object.vi' doesn't accept a 2D array of variants! So, say getting a recordset from a database (which is returned as a 2d array of variants) and
  6. Hello, I am having trouble on learning what to do after you input a file into labVIEW. I cannot seem to find help on this topics. I have seen many videos and tutorials on how to read and write excel/text (.csv) files. But, I am not able to do anything after importing an text/excel file into labVIEW. So, I was wondering if someone had a simple VI that they could share. In the end, I want to do some automation so it will read a number and a status from excel. And then that number and status will either turn on or off a switch which controls something else. Anyways, I would greatly a
  7. I need to protect an excel worksheet, and I use "USERINTERFACEONLY" As i also require some formatting such as merge cells and other option I use "ALLOWFORMATTINGCELLS" But I'm not able to run it... it say unlock and than run.... I do not want to unlock do modification and than lock method... Is there an alternative??? p.s. It works with kingsoft not with excel 2010...what?
  8. Version V1.1.0

    1,438 downloads

    This package contains VIs for reading and writing to CSV files that follow the CSV format outlined in RFC-4180 (see http://tools.ietf.org/html/rfc4180). Using this package, you can properly import CSV files that were exported from spreadsheet programs such as Microsoft Excel, Open Office or LibreOffice Calc as well as export CSV files that will be compatible with any program capable of interpreting CSV files. This implementation of the CSV format is capable of handling escaped fields such as those containing commas (or other field delimiters), multiple lines, and double quotes.
  9. View File Robust CSV This package contains VIs for reading and writing to CSV files that follow the CSV format outlined in RFC-4180 (see http://tools.ietf.org/html/rfc4180). Using this package, you can properly import CSV files that were exported from spreadsheet programs such as Microsoft Excel, Open Office or LibreOffice Calc as well as export CSV files that will be compatible with any program capable of interpreting CSV files. This implementation of the CSV format is capable of handling escaped fields such as those containing commas (or other fie
  10. After many frustrating experiences with patched together CSV parsers (admittedly of my own creation), I've finally broken down and developed a CSV file parser that follows the RFC-4180 format: http://tools.ietf.org/html/rfc4180 That is to take into account double quotes and commas inside double quotes and multiple-line entries. This is essential if you plan on storing user-input text data or storing numbers that may have a comma as a decimal point. From what I can tell, this is the same format that Open Office, Libre Office and Microsoft Excel use for their CSV file export. Therefore,
  11. Hey all, I'm working on a project which uses Excel spreadsheets as a script to run tests. Something I'd like to be able to do is embed images into the spreadsheet, then call them at points throughout the test. This would be so that all we need to run the test is the excel file, and there won't be any issues if a secondary image file is missing because it wasn't installed at the same time our script was. I have figured out how, in Excel, to embed images into comments which can be associated with cells, but I can't determine how to read those comments in LabView... I would have assumed t
  12. NOTE: while typing this up i found my solution but decided to post anyway in case it may help someone else I decided to quit beating my head off the keyboard and ask for help...I have a vi that will eventually be an .exe distributed across a variety of windows xp to windows 7 machines (32 and 64 bit). In this vi a bunch of data is saved to a .tsv file at C: i then need to open the .tsv file in excel. After some searching i found System Exec.vi. it initially seemed to be my silver bullet because if i open command line in windows and type " excel.exe c:temp.tsv" Excel is opened (and this sh
  13. Hi Team, I'm a new member, start to learn and use Labview 2 month ago. I need your assist with excel files.... I have 12 of excel files that I want to combine into one excel file. I want the data from each worksheet to get piled up into one big file, in one excel workbook. For example: First excel file A.xls with 2 worksheet A1 and A2. Second excel file B.xls with 2 worksheet B1 and B2. etc.... Finaly. I would like to creat Vi and get One Excel File (For Example... c.xls) which is including 4 worksheet --> A1, A2, B1, B2 with all the data. Thanks in advance, Nachmany
  14. Hi, I'm having a excel database with me. The excel sheet contains different data types. Column A consists of seriall Number (Integer), Column B consists of instrument description (Strings), Column C consists of model Number (Number with special characters), Column D consists of instrument Calibration date (Date), Column E consists of instrument Calibration due date and so on...... What i want to do is that i need to extract the excel sheet's content in to 2D array. And using array functions i want to compare the date and accordingly i want to do some calibration alert system. the quest
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.