Return-Path: X-Original-To: apmail-poi-user-archive@www.apache.org Delivered-To: apmail-poi-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9FECE9C85 for ; Wed, 21 Mar 2012 12:50:34 +0000 (UTC) Received: (qmail 15557 invoked by uid 500); 21 Mar 2012 12:50:34 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 15529 invoked by uid 500); 21 Mar 2012 12:50:34 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Received: (qmail 15521 invoked by uid 99); 21 Mar 2012 12:50:34 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Mar 2012 12:50:34 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of nirleshpatel@hotmail.com designates 65.55.90.162 as permitted sender) Received: from [65.55.90.162] (HELO snt0-omc3-s23.snt0.hotmail.com) (65.55.90.162) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Mar 2012 12:50:25 +0000 Received: from SNT102-W54 ([65.55.90.135]) by snt0-omc3-s23.snt0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Wed, 21 Mar 2012 05:50:04 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_04b4bebd-473a-4e9c-988e-cce1fb63ad61_" X-Originating-IP: [74.105.218.210] From: Nirlesh Patel To: Subject: RE: How to insert existing RTF string into Excel cell Date: Wed, 21 Mar 2012 08:50:03 -0400 Importance: Normal In-Reply-To: References: , MIME-Version: 1.0 X-OriginalArrivalTime: 21 Mar 2012 12:50:04.0216 (UTC) FILETIME=[22E35B80:01CD0761] X-Virus-Checked: Checked by ClamAV on apache.org --_04b4bebd-473a-4e9c-988e-cce1fb63ad61_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you Yegor. To expand on this question... I have to capture some very= simple formatted text from a webpage (e.g. HTML formatted using TinyMCE=2C= or RTF or ???) and insert the formatted text into an Excel cell - if Excel= does not recognize RTF - does it recognize HTML or any other format that I= can use with POI ? Any other options -- other than to parse the text my s= elf and apply the styles using=20 HSSFRichTextString or XSSFRichTextString? regardsNirlesh > Date: Wed=2C 21 Mar 2012 07:49:49 +0300 > Subject: Re: How to insert existing RTF string into Excel cell > From: yegor.kozlov@dinom.ru > To: user@poi.apache.org >=20 > what you want is not possible. Excel does not recognize rich > formatting in the rtf format. The only way to show rich text is to use > HSSFRichTextString object. >=20 > Yegor >=20 > On Wed=2C Mar 21=2C 2012 at 4:04 AM=2C Nirlesh Patel wrote: > > > > I have a small rtf file created using WordPad with simple formatting (b= old=2C font sizes=2C etc) I have read the file into a String and now I want= to insert String into an Excel cell and have Excel recognize the formattin= g. > > ie. I do NOT want to create a new HSSFRichTextString or XSSFRichTextStr= ing and then apply formatting. > > Is this feasible using POI? > > RegardsNirlesh >=20 > --------------------------------------------------------------------- > To unsubscribe=2C e-mail: user-unsubscribe@poi.apache.org > For additional commands=2C e-mail: user-help@poi.apache.org >=20 = --_04b4bebd-473a-4e9c-988e-cce1fb63ad61_--