f



Can not save excel file when dispose excel because the file is read-only. How can I do it?

I can not save an excel file generated by report generation toolkit in
LV becaues it is a read-only file. How can I generate a un-read-only
file?

Thanks.
0
x9561 (148441)
9/13/2004 8:41:16 PM
comp.lang.labview 35213 articles. 1 followers. vasusachin24 (1) is leader. Post Follow

3 Replies
1751 Views

Similar Articles

[PageSpeed] 44

Is my question clear enough?

What I want to do are:
1. create or open a file in LV (use Open/create/replace File.vi),
generate a new report, write data to the report, save report to file
before dispose it.

2. use subvi to enter file's path and name, don't use labview's file
dialog box or Excel's menu because we are using touch screen and they
are not big enough for fingers.

What I encountered are:
got error message after Save Report to File.vi function, which is
"Error -2146827284 occurred at Exception occured in Microsoft Office
Excel, Cannot access read-only document 'file name'.. Help Path is
C:\Program Files\Microsoft Office\OFFICE11\1033\xlmain11.chm and
context 0 in Excel_Save_Workbook.vi->Save Report to File.vi
This error code is undefined. No one has provided a description for
this code, or you might have wired a number that is not an error code
to the error code input."

2.Excel open and I can see the data was written in it, after a few
seconds later , got message from Excel which is "File Now available.
'file name' now available for editing, please select read/write for
editing." something like that.

3. the data is written to Excel, but not saved before dispose report.
so when reopen that file from excel, it is empty.

Does anyone know how to figure it out?

Thanks.
0
x9561 (148441)
9/14/2004 8:39:50 PM
Hi,

I am not sure how you want to enter the file path and name. Are you
using it as a control or constant?

Also, I tried to create a report, write a table to it and I was able
to save and dispose it without any problem.

It would be helpful if you could post a simplified part of your code
on the forum so I could get a better idea of what's going on.

Regards,
Ankita A.
0
x9561 (148441)
9/14/2004 9:15:25 PM
Thanks Ankita.

I got the problem solved. Actually, I have to leave the template path
(file name input of New Report.vi) empty, and give the file name at
the point of Save Report to File.vi.
It is related to my another question <a
href="http://exchange.ni.com/servlet/ProcessRequest?RHIVEID=101&RPAGEID=135&HOID=5065000000080000004FDC0000&UCATEGORY_0=_49_%24_6_&UCATEGORY_S=0">"how
can I creat or open an excel file in labview?" </a>

Thanks anyway.
0
x9561 (148441)
9/14/2004 9:46:45 PM
Reply:

Similar Artilces:

Can't open excel file after saving and closing excel with activex
I'm using activex to write and save excel files in LabVIEW. My application opens excel (not visible)writes a file, saves it, and then closes both the file and excel. When I try to open the file Excel opens but the file is not displayed, I see the excel header and footer but the file itself does not display. My application is still running at this point. Any suggestions? It is critical when using ActiveX with Excel that ALL refnums be properly closed when they are no longer used. Just a single refnum left open will cause the exact situation that you describe. Typically, but not require...

Saving an Excel File in format that GNUplot can read/Arrows showing through/Mukpile plots
Hi Everyone I have a good scientific brain but a poor computer brain. I have a large file in Excel with all kinds of GNU commands (set commands, etc and over 7000 data points). Every time I want to load the file I open the Excel file, copy it to the clipboard then past it into wgnuplot.exe (using windows XT). I would like to save the file in a format so that all I have to do is open wguplot and load the file. I have tried copying the file to notepad and saving it as "data.dat" etc but then gnu doesn't read it. Could someone explain step by step ( for my simple mind) as to how to do this. Also, I have almost 2000 set arrow commands ( basically vertical spikes on a topography map to represent trees). Despite setting "set hidden 3d" the arrows in certain rotations hide the topography in the back. e.g. I have a mountain with arrows in front and in back of the mountain. The arrows in the back of the mountain show right through to the front. I thought of using an error bar but they can only be used for a 2-d plot. To solve the problem I have to set some arrows with the "back" command and others with the front command. Is there anyway to create this effect without the arrows showing through? Finally, I am at a lost as to how to superimpose two 3d-graphs. I realize the answer might require a disseratation but any help is welcome. Gene In article <1126799865.678779.304810@g49g2000cwa.googlegroups.com...

read text file through Labview and then write to an excel file
Hello, &nbsp; I am relatively new with using Labview. I was wondering what would be a general method of reading data from a text file (words, sentences, numbers, and etc.) and making Labview write it on an Excel file. &nbsp; Thanks Ivan ...

Can we read excel file with matlab ?
hi, I wanted to know if we can extract datas from an excel (microsoft) file with matlab. I have 826 lines and 12 columns in my file, and I would want to put those datas in a matlab array. Does anyone know how to do it (function to use ...) ? Thank you for your help Nicolas wrote: > > > hi, > > I wanted to know if we can extract datas from an excel (microsoft) > file with matlab. I have 826 lines and 12 columns in my file, and I > would want to put those datas in a matlab array. Does anyone know > how > to do it (function to use ...) ? > > Thank you for your help Search for "Excel" in the on-line help and you will find xlsread if you have a recent version of Matlab. / per per isakson wrote: > > > Nicolas wrote: >> >> >> hi, >> >> I wanted to know if we can extract datas from an excel > (microsoft) >> file with matlab. I have 826 lines and 12 columns in my file, and > I >> would want to put those datas in a matlab array. Does anyone know >> how >> to do it (function to use ...) ? >> >> Thank you for your help Go to File , Import Wizard and navigate to the file, this will open it in Matlab Array Editor. Ade > > Search for "Excel" in the on-line help and you will find xlsread if > you have a recent version of Matlab. > > / per Nicolas wrote: > > > hi, > > I wanted to know if we can extract datas from an exce...

Can profile save like excel file?
&#305; want to save profile not html file because &#305; measure memory usage then &#305; wanna take each function allocated memory part but it is turn it like html file so can we take only allocated memort for one function sincerely &#305; paste there link &#305; want load only allocated memory part to gui is that possible? link there: http://i50.tinypic.com/16c8l5k.jpg ...

Reading the excel file from simulink block and giving as output the modified excel file to another simulink block
Hi everyone, I have created one simulink block. In the simulink block i created one embedded matlab function and trying to read an excel file and extract some particular values and give it as input to another simulink block. Could somebody tell me how to do this. The size of the excel file keeps varying. I hope iam clear else please let me know. It is very important for me to solve this problem to proceed further. Please help. Thanks Desireddy. ...

how can i best acquire analog voltages and save to an Excel file?
I looking to acquire N scans of analog input continuously over an 8 hour period. The data will be from one channel in the form of 64-70 scans per reading. I need a way to save the data to a spreadsheet for analysis later. I'm using LABView 6.1 The easiest solution is to use the Write to Spreadsheet file. This will open the text file, write the data and close the file. By enabling the append option, you can write as much data as you want in any interval. If you really want an Excel file, look at the Example called Write Table to XL. It demonstrates how to open Excel, create a workbo...

How can i save to the excel file my scanned values which are shown in a chart?
How i can do that, so that i can see the y-values corresponding to the x-values in the excel file? furthermore, i hope that i can save max. 50 separate scans to the file. I dont know is it possible to first do the scan or data aquisition, and then there is button "save", so i need something like buffer? I press button Aquisite, and then there is digital signal start and stop. After stop signal, i can see results. After that, i can save if i want. i have 2 graphs and several time measurements. But thanks for your answer, it shows the way to do movement to the excel. ...

How can I force Excel 2007 to save a file in xls format?I
I had made some code when I had Excel 2003 installed on my system. It saved workbooks in xls format. Now I have instaled Excel 2007. When I try to save the file with xls format Excel 2007 opens a dialog box asking me to select a format. I have turned the display alerts to false. What code do I need to apply to fileformat option of save as invoke node so that workbooks are saved in xls format (Excel 2003 format) and the save as dialog box would not appear. Thanks for your help! Hi rashid, if a use this function to save the file and a path is connected i get no dialog. <img src="http://forums.ni.com/attachments/ni/170/319052/1/Unbenannt.PNG"> MikeMessage Edited by MikeS81 on 04-25-2008 04:45 PM Unbenannt.PNG: http://forums.ni.com/attachments/ni/170/319052/1/Unbenannt.PNG I am impressed with your coding style (use of error no-error case structure). What does 1 imply with file-format option. Is it necessary to wire something to access mode? Can you point me to a link where I can get some detail with fileformat option?Thanks a lot for the help! Hi rashid, here is a link to the msdn help: <a href="http://msdn2.microsoft.com/en-us/library/bb214129.aspx" target="_blank">http://msdn2.microsoft.com/en-us/library/bb214129.aspx</a>. I don�t program this function for Excel2007, so i don�t know if my code is like the description tells, but it still works with 2007. Solved this funtion your problem? Mike Thanks for the link. That hel...

reading from text file to excel file
Hi, I do not know if this is right place for this, but i need some help. I have a text file, whose values are seprated by a delimiter. I want to open this file in excel, ( not import it) . I have written the driver prg in c#. The code opens the file, but it is not writting the values from text file into excel file. I can not figure out the problem here. This is my code: StreamReader dataFileReader =3D null; FileInfo file =3D null; Excel.Application ExcelObj =3D new Excel.Application(); Excel.Workbook workbook =3D null; Excel.Range...

Data from different excel files to one excel file
Hi, I have 175 cycles of battery test data, each cycle data is recorded into a excel sheet by names 1, 2, 3, ... . Every file has voltage and current. None of the cycle data is of same duration/period, the length varies. I need all the voltage data and the current data into a single excel sheet one after other. Please do reply may be: data=[]; for i=1:175 d=xlsread([num2str(i),'.xls']); data=[data;d]; % if d are columns end xlswrite('data file.xls',data) Are the individual worksheets all in a single workbook, or in multiple workbooks? ...

How can LabView's file size vi with I64 still cannot read file size larger than 4.2GB
I am trying to read file sizes using the get file/directory info vi but got incorrect file sizes if the files are larger than 4.2-4.3 GB.&nbsp; I am using LabView 8.2 and Windows XP. I wonder anyone has seen the same problem? &nbsp; Regards, Bryan This seems to be a bug in 8.20 and lower. It works fine in 8.2.1. :) &nbsp; Quote from the <a href="http://zone.ni.com/devzone/cda/tut/p/id/5674" target="_blank">LabVIEW 8.2.1 Bug Fix Information</a>: &nbsp; &nbsp; 406GLS7U Fixed an issue where the File/Directory Info function returns an incorrect size for files larger than 4 GB. &nbsp; &nbsp; ...

Want to generate Excel charts inside Excel files by Perl CGI generating Excel files using WriteExcel.pm
Hi all, My web-based application requires me to generate an Excel file with the results of an analysis in the server--something I can now do using the WriteExcel.pm module, but I'd like to do more in my Perl CGI. Specifically, I'd like to generate a graph/chart plotting values in column C in a worksheet with values in column A, and also values in column B against values in column A, both in the same graph/chart. Please note that I know how to plot a graph/chart once I open a file in Excel--my question is what I can do in the Perl CGI using WriteExcel (or associated or other Perl modules) such that when the generated Excel file is opened, the graphs/charts are already/ automatically created for me. My question is, can this be done? If so, what Perl modules are to be used. My second question is regarding regression analysis. I would like to do regression on values on a particular column, say column C against column A. I know how to do this manually after I open an Excel file. My question is, if this can be achieved using a Perl module related to WriteExcel in my Perl CGI such that the analysis is automatically performed (and the curves automatically fitted) once I open the Excel file. Any help is greatly appreciated. Thanks! dylanthomasfan <Sonny.Rajagopalan@gmail.com> wrote: > My web-based application requires me to generate an Excel file with > the results of an analysis in the server--something I can now do using > the WriteExcel.pm module, but ...

cannot delete file
cannot delete file - http://LongPathTool.com can fix it Do you have error messages?, like : Path too long. Error cannot delete file: cannot read from source file or disk Cannot delete file: Access is denied There has been a sharing violation. Cannot delete file or folder The file name you specified is not valid or too long. Specify a different file name. The source or destination file may be in use. The file is in use by another program or user. Error Deleting File or Folder Make sure the disk is not full or write-protected and that the file is not currently in use. Error Copy...

cannot delete file
cannot delete file - http://LongPathTool.com can fix it Do you have error messages?, like : Path too long. Error cannot delete file: cannot read from source file or disk Cannot delete file: Access is denied There has been a sharing violation. Cannot delete file or folder The file name you specified is not valid or too long. Specify a different file name. The source or destination file may be in use. The file is in use by another program or user. Error Deleting File or Folder Make sure the disk is not full or write-protected and that the file is not currently in use. Error Copy...

Save data in a excel file from a simulink file.
Hi! Please i need some help . I'm trying to save data from simulink file in a embedded way in one excel file with out using the command window. I know i can use the matlab function block, so use as embedded script in tha block. And tried to use the xlswrite command but without success. Can someone help me in this problem? My simulink file have one step time link to three Transfer fcn block in parallel, then i have a mux block a in the end a scope. I want to save the data information between the Transferfcn and the mux bloc. ...

Reading contents of an excel file from a test file
Hi I am writing a script to read various file types (doc, xls, pdf, html etc.) and search for certain keywords. Without caring for the file formats, I used 'findstr' system call from perl with the keyword for each file and directed the output to a text file. The results were not as bad as I had expected :) In the txt file created, I have the list of all the files and the original text from the file where the string to be searched occurs but this file has some unicode characters which prevents it to be read and processed properly. :( I basically get a lot of "" in the result test file which makes perl act wierd. Can u please suggest a way to read a text file which has unicode characters?? I do NOT want to create seperate parsers for the different file types (things like ParseExcel) as it will increase the complexity and will need a lot of effort. Cheeeeers!! KRN!!?! sorry guys.. but the unicode characters as they appear as rectangles in my text file (all appear as the same), are not printed when posting a message on this forum!! On May 15, 11:49 am, Mick <karanarora...@gmail.com> wrote: > Hi > > I am writing a script to read various file types (doc, xls, pdf, html > etc.) and search for certain keywords. Without caring for the file > formats, I used 'findstr' system call from perl with the keyword for > each file and directed the output to a text file. The results were not > as bad as I had expected :) > In the ...

how to save excel file before reading
i have to read the excel sheet after running my work.. after the save process only it reads the value.. otherwise it read the previous value.. for that what code is to be used. save my excel sheet before reading the function ...

Load an excel file into GUI do calculaton and the export the results to an Excel file
Hi guys, I wrote a function to compare some data for me and output a result if certain conditions are met. My function as of now works just great!!! However, I want to build a GUI to be able to run my function. More specifically, the GUI should load an excel file, do the comparison and then export the results to an excel file. Let's take a simple example: Suppose this is my excel file with name datain.xlsx: column1 column2 Row1 3 4 Row2 5 6 Suppose I need to add the values of row1 and all colums (i.e. 3 and 4) and also add th...

ExtenXLS loads data into Excel 2002 file but damages the Excel file.
We load data into an Excel 2002 file using ExtenXLS. The data is loaded but the Excel file is damaged only for certain samples, not for others. When the Excel file is opened after the load the following happens: The message asking to Disable / Enable macros appears twice instead of once, the Repair message shows "Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.", and the file opens but it's missing the VB modules and the formatting in the worksheets. We can't find anything wrong with the download code or the data. If anyone has any ideas what to check for please let me know. Thanks! ...

Is there a system option for OpenVMS SAS version 8 where a sas program can create an output file with a file attribute of "Stream_LF" so that these external files can b
To SAS-Lers (specifically OpenVMS Users), Is there a system option for OpenVMS SAS version 8 where a sas program can create an output file with a file attribute of "Stream_LF" so that these external files can be served through an Apache WebServer properly? Currently, what happens is when we create a CSV file, the Apache Webserver wants to load the contents of this CSV file into a single cell for Excel. That is, all OBS are treated as a SINGLE record and all the contents is loaded into a single cell within Excel. To fix this problem, we are able to use an "Convert/FDL" th...

How Can I read/write a system file from html file ?
Hello, In an html page, I use FileSystemObject to create/read/write a file. The folowing exemple run successfully on PC : <html> <head> <script> var fso = new ActiveXObject("Scripting.FileSystemObject"); var a = fso.CreateTextFile("c\testfile.txt", true); a.WriteLine("This is a test."); a.Close(); </script> </head> <body> ... </body> </html> I want to used it on Pocket PC : windows CE 2003. And when I test this exemple I have an error message that say that it can't create this ActiveX object. How can I do this ? What must I install ? Thanks. ...

Can Passport save file so it can be opened in Quark?
Can Passport save file so it can be opened in Quark? Assuming the language is English in both the Passport file and the Quark is English version (Mac OS 9, Quark, 4.11 or 5.01) Thanks Brian In article <BF028F80.59278%blgraphics@rogers.com>, Brian Lehen <blgraphics@rogers.com> wrote: > Can Passport save file so it can be opened in Quark? Assuming the language > is English in both the Passport file and the Quark is English version (Mac > OS 9, Quark, 4.11 or 5.01) > Yes -- assuming that by "Quark" you mean a regionalized version of QuarkXPress. I've never used Passport myself, so I can't tell you exactly how (although I guess it's just a "Save As"), but we have a client that uses it; when we get a file from her we can't open she just says "Whoops", resaves it somehow and resends it. -- Odysseus Brian Lehen <blgraphics@rogers.com> wrote: > Can Passport save file so it can be opened in Quark? Assuming the language > is English in both the Passport file and the Quark is English version (Mac > OS 9, Quark, 4.11 or 5.01) > > Thanks > > Brian Save as a single language version. ...

How to read an Excel file inside jar/war file
I am working with Weblogic 10 server. My requirement is to fill a template file (.xls) with some data. That means I need read this .xls file and then write into it. I put this .xls file inside the war (webapp/template/test.xls) and I use Apache POI as a library for treating MS documents. The problem is when I try to get the inputStream of this file I got an exception thrown by Weblogic. The interesting thing is that when I put this .xls file somewhere else on the server and pass an absolute Path (ex: /var/tmp/test.xls), it worked perfectly. I think this should be an issue of interaction b...

Web resources about - Can not save excel file when dispose excel because the file is read-only. How can I do it? - comp.lang.labview

Read-Only Memory
Read-Only Memory publishes high-quality books and articles that document defining moments in videogame history.

Read-only Turing machine - Wikipedia, the free encyclopedia
A read-only Turing machine or Two-way deterministic finite-state automaton (2DFA) is class of models of computability that behave like a standard ...

Read-Only Memory (@romalerts) on Twitter
Log in Sign up You are on Twitter Mobile because you are using an old version of Internet Explorer. Learn more here Read-Only Memory @ romalerts ...

Read Only Memories - Announcement Trailer - PS4 and PS Vita - YouTube
Coming Soon to PS4 and PS Vita http://readonlymemori.es Midboss is excited to announce that we're bringing the world of Neo-San Francisco to ...

Dropbox for Business folders can now be shared in read-only mode
Users of Dropbox for Business will now be able to share folders with colleagues without necessarily giving them rights to edit their content. ...

Hands-on with the Google Drive for iOS app: mostly read only
Google Drive on the iPhone. Sean Gallagher At Google's IO conference in San Francisco today, the company released a Google Drive app for Apple ...

President Obama Does Reddit AMA, Reddit Promptly Goes Into Read-Only Mode Due to Heavy Traffic
... We got a "Reddit is under heavy load right now" error page several times while trying to read the AMA, and eventually got through, but only ...

"It’s almost always a mistake to read only a first-rate writer’s masterpieces."
"A great deal of Fussell’s best, most perceptive and, frankly, most hilarious work arrived in books like 'Class: A Guide Through the American ...

Only Read This Post If You're On Your Phone
Close one eye and tilt your phone so you're looking from the charger hole. Whooaaaaaaaaa.

Only read the Facebook statuses you want to read
iPhone app Jildy says it can give users a convenient 60-second overview filtering out the statuses you won't care about.

Resources last updated: 3/28/2016 8:57:37 PM