NOTICE: This version of the NSF Unidata web site (archive.unidata.ucar.edu) is no longer being updated.
Current content can be found at unidata.ucar.edu.
To learn about what's going on, see About the Archive Site.
NOTICE: This version of the NSF Unidata web site (archive.unidata.ucar.edu) is no longer being updated.
Current content can be found at unidata.ucar.edu.
To learn about what's going on, see About the Archive Site.
> Hi Yuan - > I tried your suggested procedure, and still need help with the following > issues: > > > * IDV still seems to be taking several minutes to create the Excel file. I > have the following questions: when I execute Step 3, am I supposed to make a > selection in the menu that opens up at the very last choice (Export Grid to > Excel)? Or just wait for it to start creating the xls file using default > selections for the data? When you execute the step 3, the first window prompted is for excel output file name and location, and then the IDV will prompt a window for you to select the grid data, and you should choose the caching dataset that should be in the list. I am suppose the performance is related to your machine, it is pretty quick when I tried a model output in my machine. Yuan > * Also, I wasn't prompted for a file location and it seems to be writing > the file under the name of the original file (with the .xls extension). This > is not a problem exactly, but is there a way to have control of the naming > and location of the output file? > * Also in the window where the report of the process was being generated, > if I hit OK it seems to terminate the process. Is there a way to recover the > process? > > Thanks - > Uma > -- > Uma Shankar > Research Associate > UNC-Institute fro the Environment > Bank of America – CB# 6116 > 137 E. Franklin St Room 644 > Chapel Hill NC 27599-6116 > Phones: (919) 966-2102 (O) > (919) 441-9202 (M) > (919) 843-3113 (F) > > > Hi Uma, > I need to know what kind of data you were trying to export. If possible, > upload a small sample file here: > http://motherlode.ucar.edu/repository/alias/idvupload > Thanks, > Yuan > > Ok, let me assume your data is gridded dataset and you want to export one > parameter in the dataset to xls format. Use the following procedures: > > 1) load the dataset and create a color shaded plan view display. > 2) In the Displays tab, do File > Save > Save Data in Cache... > 3) In the Field Selector tab, Formula > Export > Export Grid to Excel.... > > In this way, you are very sure only export a 2D single parameter to excel > text format and should be fast. > > > > Yuan > > > > > > On 10/24/12 10:51 AM, "Unidata IDV Support" > > <address@hidden<mailto:address@hidden>> > > wrote: > > > > > > > >Shankar, Uma, > > > > > >Your Ticket has been received, and a Unidata staff member will review it > > >and reply accordingly. Listed below are details of this new Ticket. > > >Please make sure the Ticket ID remains in the Subject: line on all > > >correspondence related to this Ticket. > > > > > > Ticket ID: HDW-845195 > > > Subject: Exporting data from IDV to a text file > > > Department: Support IDV > > > Priority: Normal > > > Status: Open > > > > > > > > > > > >Please let us know how we can assist you further. > > > > > >Unidata User Support > > > > > > > > > > Ticket Details > =================== > Ticket ID: HDW-845195 > Department: Support IDV > Priority: Normal > Status: Closed > > > > Ticket Details =================== Ticket ID: HDW-845195 Department: Support IDV Priority: Urgent Status: Closed