You cannot post messages because only members can post, and you are not currently a member.
Description:
CsvReader and All Things Delimited
|
|
|
Text Qualifiers
|
| |
Hello
I am trying to output some data using the standard double quotes text
qualifier, where required (the default settings), but using the pipe
delimiter. I am however confused as to how the CSV writer determines
what to qualify.
I have data such as :
NULL, 1, Text, NULL, NULL, 3
and this is output as :... more »
|
|
|
Protected Worksheet and workbook
|
| |
I tried to search for answers on this but didn't find anything. Can
the DataStreams library open spreadsheets that are password
protected? I have tried and I get an exception. I was wondering if I
was doing something wrong or if it just isn't supported.
|
|
|
text to csv
|
| |
Hello,
We are working on a project on eclipse. The output in eclipse gets
displayed on the console, we can also direct it to some other file. We
are currently directing the output to a text file. To proceed with the
next part of the project we need the file in .csv format. We will be
very greatful if someone could reply how we can convert text file to... more »
|
|
|
How do you use CsvWriter to output csv data to a string
|
| |
Have a datatable full of records which need to be rendered as csv and
the result of that needs to go to a string. So have tried with below
sample code (and various iterations) to get the desired result.
However no joy as I get an empty string every time. Appreciate if
anyone can shed light on this or point out the blindingly obvious... more »
|
|
|
CSVReader - char after last field delimiter
|
| |
Bruce, I have a situation where files sent to me have a character after the last field delimiter. I am getting back an error message: Bulk Copy FAILED: Maximum column length of 100,000 exceeded in column 39 in record 2,477. Set the SafetySwitch property to false if you're expecting column lengths greater than 100,000 characters to avoid this... more »
|
|
|
xls cell date format
|
| |
Hi,
We are actively looking for a good .net library to read XLS file. One
of the constraints is that it can provide date objects from xls
without the use of FromOADate function.
Does your library do that ?
Thanks
Didrik
|
|
|
Reference Excel Cells by Cell names
|
| |
Is it possible to get to a cell by the excel cell name like "C3" or
"AA12"? I haven't seen a way thus far.
Is there a way to go directly to a named cell or range? Say I have
data starting at some arbitrary location (say C15). I would rather
have the flexibility to change that location by using a named cell.... more »
|
|
|
Export DataSet to CSV file
|
| |
Hi,
I use CSVWriter.WriteAll method to export DataTable to CSV file. It
works beautifully. However, I need to reformat one of the fields in
the table in the writing (no need to reformat the field in the
table). I know that I can read the table and parse the contents into
columes, reformat the colume and write all columes into CSV file. Is... more »
|
|
|
Display file content
|
| |
Hi,
Is there a way to display file content when writing a datatable to a
CSV file?
Thank you very much
Hugh
|
|
|
How to get individual xls cell value
|
| |
Hello Bruce,
I have an xls spreadsheet which is really messy with fields and there
are no real columns.
How do I use datastreams.xls to get the value of individual cells.
I am pretty confident I can run loops using x, y positions to get the
data I need, but I cannot figure how to get individual cell values.... more »
|
|
|
