Hi,
I have XML data in below format and i want to store XML data into Spreadsheet using OpenXML concept.
<Sales1 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ReportingCustomerId>7206489ReportingCustomerId>
  <PlanPurchaseDate xsi:nil="true" />
  <SessionId>12345SessionId>
<SalesPerson>
          <Id>0Id>
          <SequentialId>0SequentialId>
          <CreateDateTime xsi:nil="true" />
          <LastModifiedDateTime xsi:nil="true" />
          <Age>0Age>
          <DateOfBirth xsi:nil="true" />
          <FirstName>MangeshFirstName>
          <LastName>BarmateLastName>
          <BenefitAmount>0BenefitAmount>
          <VolumeAmount>0VolumeAmount>
          <ChildCount>0ChildCount>
          <MemberRenewalRateAmount xsi:nil="true" />
          <MemberCurrentRateAmount xsi:nil="true" />
          <MemberCombinedRateAmount xsi:nil="true" />
          <DependentPersonCollection />
          <RiderRates />
          <SubsciberPersonGenKey>0SubsciberPersonGenKey>
          <EnrolledPersonCount>0EnrolledPersonCount>
          <DependentRate xsi:nil="true" />
          <RatePerThousand xsi:nil="true" />
SalesPerson>

Sales1>

I want to save this XML into spreadsheet and send an email attachement of that generated spreadsheet.

Please suggest me approach for achieving this.
Thanks!