This archive contains answers to questions sent to Unidata support through mid-2025. Note that the archive is no longer being updated. We provide the archive for reference; many of the answers presented here remain technically correct, even if somewhat outdated. For the most up-to-date information on the use of NSF Unidata software and data services, please consult the Software Documentation first.
> 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