How to read the data in excel sheet

Advertisement

Dear sir,
How to read the data in excel sheet when i recieve a data serial communication... ie i have store a data in excel such that
Cell A       Cell B
   A           Apple 
   B           Ball
   C           Cat
   D           Doll
when i recieve A from serial communication i have to display Apple, and when i recieve B i have to display Ball and so on.. 

Advertisement

Hi, 
I would recommend you to have a look at the VI attached. It makes use of a VI named 'Read from Spreadsheet' to read the row and column data from the tab delimited excel file. The read data is then searched for the Alphabet specified and finally returns you the corresponding string. The test file used to validate the operation of the VI is also attached. 
Trust this would help you solve the issue. 
Regards, 
Sagar G Yadav | Application Engineer | National Instruments
Attachments:
read_from_excel.vi ‏10 KB
Book1.txt ‏1 KB

October 11, 2015

How to read the data in excel sheet

Dear sir, How to read the data in excel sheet when i recieve a data serial communication... ie i have store a data in excel such that Cell A       Cell B    A           Apple     B           Ball    C           Cat    D           Doll when i recieve

Getting short dumps while reading bulky data from excel sheet

Hi all, We have converted our non-unicode based sap system (R/3 4.7, Windows 2003, SQL 2000) into a unicode based system recently. We are facing two peculiar problems for last few days. *Problem 1 - *Whenever we want to upload the data from excel she

How to Load the data from excel file(Extension is .CSV) into the temp.table

Hi How to Load the data from excel file(Extension is .CSV) into the temporary table of oracle in Forms11g. My Forms Version is - Forms [64 Bit] Version 11.1.2.0.0 (Production) Kindly Suggest the Solution. Regards, SachinHello Sachin, You can use the

Reading the data from excel file which is in application server.

Hi, Iam trying to read the data from excel file which is in application server. I tried using the function module ALSM_EXCEL_TO_INTERNAL_TABLE. But it didn't work. I tried just reading using open data set and read data set it is giving junk character

How can i download data in excel sheet .

Hi all My Requirement : In a selection screen after giving a VBELN,It will show all the related data from VBRP table through alv  . There are a customize icon ,after clicking the icon it will download all fetched data . Can any one help me .how can i

How to set the Date in excel through Java?

now i am using cell.setCellValue(date); date is in format of "dd/MM/yyyy" But when it set on excel , it sets as number. I need the date as in same format as what i given. Assist me.Consult the docs of the API you're using. We can't say much abou

How to read the data in a txt file on a web site?

I want to extract the numbers located in txt files on a web site. It's a normal url. Not a ftp. Does anyone know how to do it?Hi Tom, What do you want to extract from the text file?? I wanted to extract an IP address from a pearl script from my FTP s

Read data from excel sheet and then perform the required operations.

Hi all I need to write a procedure which can read data from excel sheet.I have excel sheet in which i have to options one is modification and other is addition.so if it reads modification then i need to read the concerned table name then check its av

How to export the data as integer into excel sheet?

Hi All,      I am working on export to excel functionality and using JEXCEL API to create it.  When I export the data to excel sheet, the data are stored in text format in the excel sheet.  If I click on summation button on excel sheet,  it is not su

Downloading table data into Excel sheet - Webdynpro Java

Hi All, We have developed a custom webdynpro application that executes an RFC and displays data in Table UI element. We have provided a button to download the data in excel sheet. When data is huge like, total number of rows filled up in the table ar

How to populate the Quering data into Excel sheet in Oracle

Dear Guys, How to populate the Quering data into Excel sheet in oracle. Please provide a solution. Thanks & Regards, Senthil K KumarHi To make Excel sheets from sqlplus, you can use the markup html tag in sqlplus. Here's an example. Example <code&g

How to  send ALV output data into Excel sheet format via Mail to the user?

Hi friends, I have a doubt ie, How to  send ALV output data into Excel sheet format via Mail to the user? regards MoosaHi, Provide the output internal table to the objbin in the below FM Send Message   CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'   

How to downlaod vednor master data into excel sheet in SAP Application ser

Hi friends I want to download SAP vendor master data into excel sheet and the file should be stored in SAP Application server Location with padding zeros. Please help me. ThanksHi Ramesh, You can download the data into application server using the fo

How can i export the data to excel which has 2 tables with same number of columns & column names?

Hi everyone, again landed up with a problem. After trying a lot to do it myself, finally decided to post here.. I have created a form in form builder 6i, in which on clicking a button the data gets exported to excel sheet. It is working fine with a s

HOW CAN I GET THE TIME IN EXCEL SHEET USING WRITE TO MEASUREMENT INSTRUCTION

HI, I am using GET TIME IN SECONDS ,and after that i placed SECONDS TO DATE /TIME instruction ,and i had taken a write to measurement file instruction to get the time in excel sheet. Now i am not able to connect write to measurement source to seconds

How can i read the data fromtext fieldsin the form of bytes??

Hi friends, How can i read the data fromtext fieldsin the form of byte string while using Socket connection. I have two text fields. i need to send the data from the textfeilds to the server using a byte string. Can anyboday help me??? KKDoes <cfdbin

How to read  input data of the process which running fine

Hi Guys, How to read the recently completed BPEL PROCESSes input data ( input xml) . Please help me. Regards janardhanSome browsers behave differently, FireFox 2 generally works better than FireFox 3 and IE. If you select the process that has run fro

To transfer data in excel sheet..

hi experts,      please let me know how do we transfer the sap data to excel sheet?...using any method.. thanks in advance...Hi, If you are using ALV there should be an icon ( F9 Function ) for download to spreadsheet also using GUI_DOWNLOAD FM also

Export Data into Excel Sheet in UNIX

Hi All How to export the table data into excel sheet in unix. ThanksCreate a csv file. A csv file is just an ascii file, so it doesn't matter what OS you are on.Read other 2 answers

Problem while exporting data to Excel sheet.......

Hi I have written the following code to export data to excel sheet... data:        conv_out TYPE REF TO cl_abap_conv_out_ce,        content TYPE xstring. data : itab_slsrl type table of znslsrlitm. data: xml_out TYPE string. Data: Node_slsrl type ref