
<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Soma,<div class=""><br class=""></div><div class="">This is a help forum for NCL coding issues, not Microsoft Excel. I suggest you search in one of the Microsoft Excel forums in this list: <a href="https://www.deskbright.com/excel/excel-help-forum/" class="">https://www.deskbright.com/excel/excel-help-forum/</a><br class=""><div class=""><br class="webkit-block-placeholder"></div><div class="">

<div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div>Toni<br class=""><br class=""><b class="">Toni Klemm, Ph.D.<br class=""></b>Postdoctoral Research Associate<br class="">Department of Ecosystem Science and Management<br class="">College of Agriculture and Life Sciences<br class="">Texas A&M University, College Station, TX<br class=""><a href="http://www.toni-klemm.de" class="">www.toni-klemm.de</a> | <a href="http://www.twitter.com/toniklemm" class="">@toniklemm</a><br class="">Editorial Board member, <a href="http://www.eccforum.org" class="">Early Career Climate Forum</a><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""></div></div></div></div>

</div>

<div><br class=""><blockquote type="cite" class=""><div class="">On Nov 8, 2019, at 9:19 AM, Soma Roy <<a href="mailto:somaroy892@gmail.com" class="">somaroy892@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="auto" class="">MS Excel..<div dir="auto" class=""><br class=""></div><div dir="auto" class="">Soma</div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Nov 8, 2019, 20:47 Toni Klemm <<a href="mailto:toni-klemm@tamu.edu" class="">toni-klemm@tamu.edu</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word;line-break:after-white-space" class="">Soma,<div class=""><br class=""></div><div class="">Please always do reply-all so that <a href="mailto:ncl-talk@ucar.edu" target="_blank" rel="noreferrer" class="">ncl-talk@ucar.edu</a> is included in the email and the email conversation is archived in a help database.</div><div class=""><br class=""></div><div class="">I’m not sure I understand. What do you mean by “excel”? Are you working in Microsoft Excel or in NCL?</div><div class=""><br class=""></div><div class="">Toni<br class=""><div class=""><div class="">

<div dir="auto" style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; text-decoration: none; word-wrap: break-word; line-break: after-white-space;" class=""><div dir="auto" style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; text-decoration: none; word-wrap: break-word; line-break: after-white-space;" class=""><div dir="auto" style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; text-decoration: none; word-wrap: break-word; line-break: after-white-space;" class=""><div class=""><br class=""><br class=""><b class="">Toni Klemm, Ph.D.<br class=""></b>Postdoctoral Research Associate<br class="">Department of Ecosystem Science and Management<br class="">College of Agriculture and Life Sciences<br class="">Texas A&M University, College Station, TX<br class=""><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.toni-2Dklemm.de&d=DwMFaQ&c=u6LDEWzohnDQ01ySGnxMzg&r=zmhRVp0i4wZ5_1Ujh0fnRXAExHgKLTQu0rZLW7PxKA4&m=mUHpe5otgmPD47USa2mo9hBd39I2QvIFljnatc5NRp8&s=Fa-5oIFi3Gd3rLbdwQx6gR8cVcp3rgbAC5a_3WZ68F8&e=" target="_blank" rel="noreferrer" class="">www.toni-klemm.de</a> | <a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.twitter.com_toniklemm&d=DwMFaQ&c=u6LDEWzohnDQ01ySGnxMzg&r=zmhRVp0i4wZ5_1Ujh0fnRXAExHgKLTQu0rZLW7PxKA4&m=mUHpe5otgmPD47USa2mo9hBd39I2QvIFljnatc5NRp8&s=hoLgtTdIgWvBvnbtjK4E37EkqBL_FkX-0WccoGwLQxM&e=" target="_blank" rel="noreferrer" class="">@toniklemm</a><br class="">Editorial Board member, <a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.eccforum.org&d=DwMFaQ&c=u6LDEWzohnDQ01ySGnxMzg&r=zmhRVp0i4wZ5_1Ujh0fnRXAExHgKLTQu0rZLW7PxKA4&m=mUHpe5otgmPD47USa2mo9hBd39I2QvIFljnatc5NRp8&s=dQNm3uuTxN4I0gG4okMZk3kyR9JNWFTr0tATd9Ah4uQ&e=" target="_blank" rel="noreferrer" class="">Early Career Climate Forum</a><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""></div></div></div></div>

</div>

<div class=""><br class=""><blockquote type="cite" class=""><div class="">On Nov 8, 2019, at 8:34 AM, Soma Roy <<a href="mailto:somaroy892@gmail.com" target="_blank" rel="noreferrer" class="">somaroy892@gmail.com</a>> wrote:</div><br class=""><div class=""><div dir="auto" class="">I only need to save individual crop field from col. to individual excel within individual crop folder name .<div dir="auto" class=""><br class=""></div><div dir="auto" class="">I only need to save data in excel only.</div><div dir="auto" class=""><br class=""></div><div dir="auto" class=""><br class=""></div><div dir="auto" class="">Soma</div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Nov 8, 2019, 20:01 Toni Klemm <<a href="mailto:toni-klemm@tamu.edu" target="_blank" rel="noreferrer" class="">toni-klemm@tamu.edu</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word;line-break:after-white-space" class="">Hi Soma,<div class=""><br class=""></div><div class="">Could you be more specific? What do you mean by “merged excel” and “individual excels”? Are you talking about reading data from a Microsoft Excel file into NCL? If yes, then in my experience it works best if you save individual the Excel spreadsheets as .csv file and then read them into NCL. Here is some help: <a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ncl.ucar.edu_Applications_read-5Fcsv.shtml&d=DwMFaQ&c=u6LDEWzohnDQ01ySGnxMzg&r=zmhRVp0i4wZ5_1Ujh0fnRXAExHgKLTQu0rZLW7PxKA4&m=4FjnD_RwBolYfkjKApmQxfQZ0c6hUMPW3M0BjGJ-MIQ&s=OkpaxpSDwrJPQcPGe5agrpmjJtZTJNQ_HaKAWmaKyXA&e=" rel="noreferrer noreferrer" target="_blank" class="">https://www.ncl.ucar.edu/Applications/read_csv.shtml</a></div><div class=""><br class=""></div><div class="">If that’s not what you want to do, could you attach the file you want to work with and explain it more? That might help us understand what you want to do. </div><div class=""><br class=""></div><div class="">Toni</div><div class=""><div class="">

<div dir="auto" style="letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;word-wrap:break-word;line-break:after-white-space" class=""><div dir="auto" style="letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;word-wrap:break-word;line-break:after-white-space" class=""><div dir="auto" style="letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;word-wrap:break-word;line-break:after-white-space" class=""><div class=""><br class=""><br class=""><b class="">Toni Klemm, Ph.D.<br class=""></b>Postdoctoral Research Associate<br class="">Department of Ecosystem Science and Management<br class="">College of Agriculture and Life Sciences<br class="">Texas A&M University, College Station, TX<br class=""><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.toni-2Dklemm.de&d=DwMFaQ&c=u6LDEWzohnDQ01ySGnxMzg&r=zmhRVp0i4wZ5_1Ujh0fnRXAExHgKLTQu0rZLW7PxKA4&m=4FjnD_RwBolYfkjKApmQxfQZ0c6hUMPW3M0BjGJ-MIQ&s=_rQfyvZzEElaUm5IDOkQ7ve3Idn8aAXQucPQ2zW8YiQ&e=" rel="noreferrer noreferrer" target="_blank" class="">www.toni-klemm.de</a> | <a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.twitter.com_toniklemm&d=DwMFaQ&c=u6LDEWzohnDQ01ySGnxMzg&r=zmhRVp0i4wZ5_1Ujh0fnRXAExHgKLTQu0rZLW7PxKA4&m=4FjnD_RwBolYfkjKApmQxfQZ0c6hUMPW3M0BjGJ-MIQ&s=oU_wAJfxrpz1jWU5S11c0zWXGxlmYD0Zc-fot_p7S8w&e=" rel="noreferrer noreferrer" target="_blank" class="">@toniklemm</a><br class="">Editorial Board member, <a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.eccforum.org&d=DwMFaQ&c=u6LDEWzohnDQ01ySGnxMzg&r=zmhRVp0i4wZ5_1Ujh0fnRXAExHgKLTQu0rZLW7PxKA4&m=4FjnD_RwBolYfkjKApmQxfQZ0c6hUMPW3M0BjGJ-MIQ&s=r6wJTipl2OEMvqDUCGCwO_f4YuKU3y7hrffl7gKGsaE&e=" rel="noreferrer noreferrer" target="_blank" class="">Early Career Climate Forum</a><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""><br class=""></div></div></div></div>

</div>

<div class=""><br class=""><blockquote type="cite" class=""><div class="">On Nov 8, 2019, at 2:50 AM, Soma Roy via ncl-talk <<a href="mailto:ncl-talk@ucar.edu" rel="noreferrer noreferrer" target="_blank" class="">ncl-talk@ucar.edu</a>> wrote:</div><br class=""><div class=""><div dir="auto" class="">Hello NCL Users,<div dir="auto" class=""><br class=""></div><div dir="auto" class="">I want to extract crop data from a merged excel to individual excels under different crop name folders for each districts for a state.</div><div dir="auto" class=""><br class=""></div><div dir="auto" class="">Can anyone help me in this issue?</div><div dir="auto" class=""><br class=""></div><div dir="auto" class="">Regards,</div><div dir="auto" class="">Soma</div></div>

_______________________________________________<br class="">ncl-talk mailing list<br class=""><a href="mailto:ncl-talk@ucar.edu" rel="noreferrer noreferrer" target="_blank" class="">ncl-talk@ucar.edu</a><br class="">List instructions, subscriber options, unsubscribe:<br class=""><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__mailman.ucar.edu_mailman_listinfo_ncl-2Dtalk&d=DwICAg&c=u6LDEWzohnDQ01ySGnxMzg&r=zmhRVp0i4wZ5_1Ujh0fnRXAExHgKLTQu0rZLW7PxKA4&m=ET_0YWAvBBQ5yd4ifwtTbMGSaVca2E1Z9XguNEwN5Mw&s=XsnZHWqPbu7uAPQhStsn7WVqPok-q5u0UICU-IBV7E8&e=" rel="noreferrer noreferrer" target="_blank" class="">https://urldefense.proofpoint.com/v2/url?u=http-3A__mailman.ucar.edu_mailman_listinfo_ncl-2Dtalk&d=DwICAg&c=u6LDEWzohnDQ01ySGnxMzg&r=zmhRVp0i4wZ5_1Ujh0fnRXAExHgKLTQu0rZLW7PxKA4&m=ET_0YWAvBBQ5yd4ifwtTbMGSaVca2E1Z9XguNEwN5Mw&s=XsnZHWqPbu7uAPQhStsn7WVqPok-q5u0UICU-IBV7E8&e=</a> </div></blockquote></div><br class=""></div></div></blockquote></div>

</div></blockquote></div><br class=""></div></div></div></blockquote></div>

</div></blockquote></div><br class=""></div></body></html>