**SAS to excel**Hello, I used ODS to output data as an excel file. In the file there
is a field with numbers like '95-1234',
'03-2345', etc. However, when I opened the file in excel, it displays
a date for these numbers. What do I need
to do to keep numbers the way they should be? TIA
Here is the code to output the data:
ods html file='/projects/example.xls' style=minimal;
proc print data=test;
run ;
ods html close ;
With this kind of transfer sometimes it is necessary to send Excel
instructions on
formatting a particular item....
Try something like this in your proc print.....

**User Entered Data(Read Only Data) to Excel**Hi All,
I am new to Ruby, new task has been given to me by the company and they
asked me to use ruby for it
1. Capture the User Entered data's in a webpage which is Readonly
( Data's can be in Text, List, Radio button, Check box)
i need to capture the datas present in above fields and export to Excel
with column heading.
People please help me to solve this problem
i dont know how and where to start
Regards
Md Rafiq
--
Posted via http://www.ruby-forum.com/.
...

**the data that is in the table is from excel, so the data to be read can changed?**for example the data before is EXEC 1,how if i'll changed the value to
1 how can i read those data if he changed the EXEC 1 to 1. that's why
i said the data is changeable.
can you give me a simple example about this?
Thank You
thank you for your help, but how if EXEC 1 can
be EXECUTE 1 of EXE 1. I use the scan from string and it only reads
EXEC, EXECUTE and EXE not 1 and space. Either EXECUTE 1, EXEC 1, EXE 1
and 1 can be the value that can get from excel.
The string parse example is working at LV 7.0, I'm using LV 6.1.
...

**read data from 2 excel sheets and write both into 1 excel sheet**Greetings. Let me explain this a bit. I am wondering what would be the best way to go about this.
I have 2 small Excel spreadsheets. I want to be able to read the first 5 cells in the first row from each spreadsheet.
I then want to write the data from those 2 sheets into a third different spreadsheet starting in different columns.
I do not have the Excel Report set. I was hoping to do this with active X, but I'm not sure if this can be done.
Thank you,
bob
Hi RLemo, yes it is possible. See this thread for more informatio...

**Reading data from Excel...**Hi,
I have a Excel sheet that have a column with mixed data:
column can contain data like "892-234-32A" or like "892298343233432"
I need to get all data column such as "text" to avoid numeric field show as
exponential number.
I'm trying with:
SELECT CAST (CODICE as bigint(25)) FROM
OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel
8.0;IMEX=1;HDR=YES;Database=C:\tempxadp\dist1.xls', Foglio1$)
But I get error conversion type "from nvarchar to bigint" when query meet
the alphanumeric field.
Any tips ?
Thanks in advance
Piero
Italy
...

**how to read data from EXCEL**I need to read data from EXCEL worksheets in this way:
The script perl asks me to write a number .
I type a Number f.e. 1000 , the script should look for the number 1000
inside a
excel worksheet file and if it find it, should capture all the other
numbers reported in the raw where there is the number 1000.
the mother number (1000) is always in the first colomn of excel sheet.
col1 col2 col3 col4 col5
raw1 900 002 004 006
raw2 1000 345 445 888 777
once the script had found the wanted number (1000) in the raw2 col1 ,
it giv...

**Problem in reading excel sheet data from sheet .How to usw this data for further for identification of model**Hello,
1)I have CSTR data for Two In put Two Out put System(Temp, Flow).
Data is in Excel sheet format(stored in PC desk top).
I have use xlsread function (by giving correct path ) to read data .It gives me error.
what should I do now to read my excel sheet data.
2) After getting the data from excel sheet .I want to find the model of this process. So is " iduidemo " will be helpful for me. In iduidemo file type is .sid how to create .sid file from excel sheet. data.
3) Is there any other way to find first order plus delay time model using process react...

**Read data from excel**Hi, I have a problem while reading data from excel.
Every cell in my excel file is in the format:
1234;5678
However, I need to read both numbers, how can I do this?
Is there any formula for this?
"Ying Yap" <yyap1@iit.edu> wrote in message
<g40a3a$lcr$1@fred.mathworks.com>...
> Hi, I have a problem while reading data from excel.
> Every cell in my excel file is in the format:
> 1234;5678
> However, I need to read both numbers, how can I do this?
> Is there any formula for this?
If you excel file has data like 12;34;56, you can try to
save this file as ...

**Reading excel data**I have generated a "dat" file from a mathematica simulation. I then
brought the data back into Mathematica to graph using the code below.
All of this worked fine. Then, when I did a few manipulations in excel
on the "dat" file (adding a column of data) and resaved the file as a
tab delimited file as it was before my manipulations, the code below
does not work. I get the following error messages.
Transpose::nmtx: The first two levels of the one-dimensional list
cannot be transposed
Part::partw: Part All of the Transpose... does not exist.
I did not manipulate at...

**READ DATA IN EXCEL**Dear all,
I made a SAS code to read some data in an excel file. It works fine.
However, I have data in the excel spreadsheet up to line 61. However,
SAS reads data until line 147 (it reads until line 147 but considers
for analysis only the first 60 data, which is correct). Dou you know
how I can teel SAS to read only the first 60 data? Please, see my code
below. Thanks in advance for any help (sorry if it is a simple
question, but I am new to SAS).
Regards,
R=F4mulo
PROC IMPORT DBMS=3DEXCEL OUT=3DWORK.FABIO REPLACE
DATAFILE=3D"C:\FABIOTE.XLS";
SHEET=3D"NNP";
GETNAMES=3D...

**reading Excel data**I have a question on reading Excel data where all the Excel cells are not
necessarily formatted the same way. I have an Excel file where one column
contains ID numbers that need to be read as character variables (they are
all numbers but many have leading zeros). In my Excel spreadsheet, the
observations that have leading zeros have a "carrot" in the left part of
the cell, and when you look at the actual contents of the cell, it looks
like this:
'000357849 (note the ' preceding the number). When I use proc import, SAS
reads all these cells as missing. For Excel values tha...

**reading data from excel**Dear friends,
Does any one know how to read data from an excel sheet having data in
many columns?. I tried xlsread, but it reads only the first column.
thanks!
sohail
Maybe you didn't use the function xlsread correctly. Here is an
example of an Excel file with 10 columns:
A = rand(8,10);
B = xlswrite('myfile.xls',A);
C = xlsread('myfile.xls');
sohail wrote:
>
>
> Dear friends,
>
> Does any one know how to read data from an excel sheet having data
> in
> many columns?. I tried xlsread, but it reads only the first column.
>
> thanks!
> sohai...

**How to Read data from excel file without converting a excel file into .csv or any other format**Hello,
Can somebody suggest me how to read from an excel file (consisting of 10 work sheets) to an array?
Thanks,
She
Hello,
it's right that you can use activeX. (For example with rhe report generation toolbox from ni) But there are some problems:
1. You have to have excel installed on the targed PC. (to get the ActiveX interface)
2. There exists different "Microsoft Excel x.x Object Library Version x.x" which have different methods and properties. If a costumer has an other version, it could be that it doesn't work.
3....

**read excel data**I
I also have problem reading data from excel. I have a data
table (tab delimited) that I would like to read into the vi.
and consequently plot it into 3D graph. The data I attached
is generated by me to
simulate measured(real) data that I do not have yet.
The vi. I?m using to read the data for some reason generates
error.
Can anyone help me in troubleshooting both the excel
spreadsheet
and the vi.
Thanks,
Milutin
My missing attachments.
3d testdata sample.xls:
http://forums.ni.com/attachments/ni/170/281978/1/3d testdata sample.xls
Excel tabletoarr...

**Reading Data from Excel**
Hi every one,
I am trying to build an applicatiuon which is supposed to read some data
from excel spread sheet. can some one please help me in showing how. The
excel file is created by other application and I have no control over it. My
application will only open that file and read data from some cols specified
by me.
Thanks
"Ajay Tiku" <TikuA@Lifepredictiontech.com> wrote in message
news:RcadnTcvD5-qjundRVn-uQ@magma.ca...
>
> Hi every one,
>
> I am trying to build an applicatiuon which is supposed to read some data
> from excel spread sheet. can some one p...

**READING DATA FROM EXCEL**Hi i'd like to read data from excel. i found on the forum this VI (see attached) but it doesn't work for some unwired links.
could some one help please?
Regards
Tchaou
Read_Value_From_Excel.vi:
http://forums.ni.com/attachments/ni/170/232148/1/Read_Value_From_Excel.vi
readfromexel.vi:
http://forums.ni.com/attachments/ni/170/232148/2/readfromexel.vi
From the VBA help file concerning the change from Value to Value2:
The only difference between this property and the Value property is that the Value2 property doesn?t use the C...

**how to read data from excel?**We wrote the general code likie this:
clear all;clc;
[data, name]=xlsread('MFIN6201 Group Assignment Data Spreadsheet.xls');
y = getnameidx(name, {'ASX200'});
x1=getnameidx(name, {'Unemployment','D2:D65'});
Y=data(:,y);
[m n]=size(data);
m=length(data);
one=ones(m,1);
X1=[one data(:,x1)];
But it keeps showing error:
Attempted to access data(:,0); index must be a positive integer or logical.
Error in Group_assignment (line 7)
Y=data(:,y);
this is the first step of our assignments, really need to solve it asap.
Many thanks
On Sunday,...

**Reading data from Excel**Hi All,
Has anyone found a quick way of getting values from an Excel
spreadsheet.
When putting data into a spreadsheet you can get the range for the area
and set the value to an array that then updates all of the cells in one
go and its quite quick.
When getting the data back I can't seem to find any other way than
getting each cell as its own range - which is quite slow.
For example this is what I'm currently doing:
FOR dwCount := 1 UPTO dwMax //loop for each column we need to
process for this row.
sCellRef := aFields[dwCount,2]+NTrim(dwXLRow) ...

**reading excel data**Hello, I've built a model in Scicos representing a physical system. I
am now trying to set an input from some measurements I made to see the
response of the system. The point is that I don't understand the way
external data should be imported in scicos. Is it possible to find a
source block to read data from an excel sheet?
alexandre
alexandre.cluzet@voila.fr wrote:
> Hello, I've built a model in Scicos representing a physical system. I
> am now trying to set an input from some measurements I made to see the
> response of the system. The point is that I don&#...

**reading binary data**Hello,
I've problems reading a binary data file. I have the information
about the content of the binary file and programmed the m-file to
read the binary data.
After I read a certain part of data, I read more, the I should
have... I checked the fread-commands several times, but there is
everything ok. When reading the data in C, there are no problems.
Did anybody have similar problems and solved them?
Thanx, Harald
...

**HOW read a data from word and excel**Hi to all,
i want to generate a report by reading the raw data from EXCEL and
WORD ,
how use infile statement,
can anybody help me
have a nice day
Srini
...

**How to read excel data into an array?**Dear all:
I want to use the excel data to build an array (2D)and then operate it in labview 7.1, but I can just do my vi in the stage, can any one help me to read the excel data and build an array first.Here is my vi and the excel file.Thanks for you help.
project.vi:
http://forums.ni.com/attachments/ni/170/205282/1/project.vi
data.xls:
http://forums.ni.com/attachments/ni/170/205282/2/data.xls
Is there a way to read excel data without select the range ? Where excel file takes the place i...

**how to read datas from an excel file**i have datas in an excel file like this:
names surnames
jack white
smith black
marry brown
how can i read these datas for ex i know that names in the cell A1 and
surnames is next to it?
Hi,
Unless you know excell's format it probably is easier to save the excell
sheet as csv file and then do something like this
#include <ifstream>
#include <string>
#include <sstream>
using namespace std;
int main()
{
int RetVal = 0;
try
{
ifstream Input( "excell.csv" );
// Testing if open etc.
string Line Name, Surname;
while( getline( Input...

**excel with large data read**Hi all.
I have a question about the data read of the excel.:smileysad:
I have 15238 rows* of data 22 column of data in an excel file and LabVIEW need a very long time to read the excel.I don't know if my program is not good enough to manage the large data or it is normal for that.
Besides, I have tried to convert the excel data to csv data and use text file read method to read but it seems that it also need a very long time to read.
Actually, is there any better methods to read large amount of data? Does Access a good slution for that?
&am...