Single Quote Problem in Excel to Export

[Prasad Dannani]

Hi,

We have to export our data in sql server table to any excel sheet. We have a
template to export, using oledb we are inserting rows to this template and
generating the excel output.

The problem here is we are getting a single quote extra in front of each
cell. can anyone help us in clearing this kind of an issue.

we tried sending some static strings to some columns on for taking from sql
server eventhen we are getting the same


Its Urgent, Please reply ASAP,
Prasad Dannani

[Alvin Bruney - ASP.NET MVP]

That's how excel forces data to be a string. You will have to write code to
remove it. Or you can set the cell to a date type or some other relevant
type to get rid of the quote character.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ [url]www.lulu.com/owc[/url]
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------



"Prasad Dannani" <prasad@pennywise.com> wrote in message
news:ukF#CRl2FHA.1396@TK2MSFTNGP15.phx.gbl...

> Hi,
>
> We have to export our data in sql server table to any excel sheet. We have

a

> template to export, using oledb we are inserting rows to this template and
> generating the excel output.
>
> The problem here is we are getting a single quote extra in front of each
> cell. can anyone help us in clearing this kind of an issue.
>
> we tried sending some static strings to some columns on for taking from

sql

> server eventhen we are getting the same
>
>
> Its Urgent, Please reply ASAP,
> Prasad Dannani
>
>
>

[Prasad Dannani]

We tried by specify the datatype to the oledb parameters, We tried to find
that charecter in the string which are retreive from sql server but it was
not there and then we removed the first charecter and tried then we also
tried by hardcoding the values to one or two columns. We tried by specfying
the datatype to text in the excel template.

None of the above are worked. If there is any otherway to remove it then
please inform us.

"Alvin Bruney - ASP.NET MVP" <www.lulu.com/owc> wrote in message
news:eSy1a5l2FHA.3704@TK2MSFTNGP10.phx.gbl...

> That's how excel forces data to be a string. You will have to write code

to

> remove it. Or you can set the cell to a date type or some other relevant
> type to get rid of the quote character.
>
> --
> Regards,
> Alvin Bruney [MVP ASP.NET]
>
> [Shameless Author plug]
> The Microsoft Office Web Components Black Book with .NET
> Now Available @ [url]www.lulu.com/owc[/url]
> Forth-coming VSTO.NET - Wrox/Wiley 2006
> -------------------------------------------------------
>
>
>
> "Prasad Dannani" <prasad@pennywise.com> wrote in message
> news:ukF#CRl2FHA.1396@TK2MSFTNGP15.phx.gbl...

> > Hi,
> >
> > We have to export our data in sql server table to any excel sheet. We

have

> a

> > template to export, using oledb we are inserting rows to this template

and

> > generating the excel output.
> >
> > The problem here is we are getting a single quote extra in front of each
> > cell. can anyone help us in clearing this kind of an issue.
> >
> > we tried sending some static strings to some columns on for taking from

> sql

> > server eventhen we are getting the same
> >
> >
> > Its Urgent, Please reply ASAP,
> > Prasad Dannani
> >
> >
> >

>
>

[Prasad Dannani]

We tried all possible combinations and finally able to find that the problem
is there in the excel template i specified the cells format type to text
then it worked properly.



"Prasad Dannani" <prasad@pennywise.com> wrote in message
news:%237myn%23l2FHA.1276@TK2MSFTNGP09.phx.gbl...

> We tried by specify the datatype to the oledb parameters, We tried to find
> that charecter in the string which are retreive from sql server but it was
> not there and then we removed the first charecter and tried then we also
> tried by hardcoding the values to one or two columns. We tried by

specfying

> the datatype to text in the excel template.
>
> None of the above are worked. If there is any otherway to remove it then
> please inform us.
>
> "Alvin Bruney - ASP.NET MVP" <www.lulu.com/owc> wrote in message
> news:eSy1a5l2FHA.3704@TK2MSFTNGP10.phx.gbl...

> > That's how excel forces data to be a string. You will have to write code

> to

> > remove it. Or you can set the cell to a date type or some other relevant
> > type to get rid of the quote character.
> >
> > --
> > Regards,
> > Alvin Bruney [MVP ASP.NET]
> >
> > [Shameless Author plug]
> > The Microsoft Office Web Components Black Book with .NET
> > Now Available @ [url]www.lulu.com/owc[/url]
> > Forth-coming VSTO.NET - Wrox/Wiley 2006
> > -------------------------------------------------------
> >
> >
> >
> > "Prasad Dannani" <prasad@pennywise.com> wrote in message
> > news:ukF#CRl2FHA.1396@TK2MSFTNGP15.phx.gbl...

> > > Hi,
> > >
> > > We have to export our data in sql server table to any excel sheet. We

> have

> > a

> > > template to export, using oledb we are inserting rows to this template

> and

> > > generating the excel output.
> > >
> > > The problem here is we are getting a single quote extra in front of

each

> > > cell. can anyone help us in clearing this kind of an issue.
> > >
> > > we tried sending some static strings to some columns on for taking

from

> > sql

> > > server eventhen we are getting the same
> > >
> > >
> > > Its Urgent, Please reply ASAP,
> > > Prasad Dannani
> > >
> > >
> > >

> >
> >

>
>