csv.reader(): Limit the number of columns read in Windows

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

csv.reader(): Limit the number of columns read in Windows

caleb_cruze
Programmer named Tim

Posts: 7

Threads: 0

Joined: Dec 2020

Reputation: 0

Dec-31-2020, 07:50 AM

Microsoft Excel has a maximum of 255 columns. Importing a CSV record with more than 255 fields can cause some versions of Microsoft Excel to exhibit strange behavior. That is probably why you're only able to do a maximum of 255 fields with the OleDBDataAdapter.

Regards,
Caleb

Find

Messages In This Thread

csv.reader(): Limit the number of columns read in Windows - by Pedroski55 - Dec-25-2020, 12:00 AM

RE: csv.reader(): Limit the number of columns read in Windows - by Gribouillis - Dec-25-2020, 09:27 AM

RE: csv.reader(): Limit the number of columns read in Windows - by Larz60+ - Dec-25-2020, 11:42 AM

RE: csv.reader(): Limit the number of columns read in Windows - by pjfarley3 - Dec-25-2020, 07:59 PM

RE: csv.reader(): Limit the number of columns read in Windows - by Pedroski55 - Dec-26-2020, 02:47 AM

RE: csv.reader(): Limit the number of columns read in Windows - by Gribouillis - Dec-26-2020, 07:31 AM

RE: csv.reader(): Limit the number of columns read in Windows - by pjfarley3 - Dec-27-2020, 05:39 AM

RE: csv.reader(): Limit the number of columns read in Windows - by Pedroski55 - Dec-27-2020, 07:18 AM

RE: csv.reader(): Limit the number of columns read in Windows - by caleb_cruze - Dec-31-2020, 07:50 AM

RE: csv.reader(): Limit the number of columns read in Windows - by pjfarley3 - Jan-23-2021, 01:03 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Read complete windows registry?	fredep57	3	1,004	Mar-15-2023, 08:14 PM Last Post: buran
	Read directory listing of files and parse out the highest number?	cubangt	5	2,523	Sep-28-2022, 10:15 PM Last Post: Larz60+
	xml simple reader	kucingkembar	2	1,112	Aug-19-2022, 08:51 PM Last Post: kucingkembar
	Having strange results from an RFID HID card reader - I'm stuck	orbisnz	1	1,553	Mar-28-2022, 08:20 AM Last Post: Larz60+
	Thoughts on interfacing with a QR code reader that outputs keystrokes?	wrybread	1	1,539	Oct-08-2021, 03:44 PM Last Post: bowlofred
	Remove Specific Columns when the number of columns is greater than a specific value	CuriousOne	0	1,362	Sep-09-2021, 09:17 PM Last Post: CuriousOne
	NFC reader code help	johnroberts2k	1	2,662	Jul-02-2021, 08:43 PM Last Post: deanhystad
	[Solved] Using readlines to read data file and sum columns	Laplace12	4	3,683	Jun-16-2021, 12:46 PM Last Post: Laplace12
	Read strings and numbers in columns from a file	suvadip	4	3,006	Aug-11-2020, 09:37 PM Last Post: suvadip
	Closing Files - CSV Reader/Writer	lummers	2	2,667	May-28-2020, 06:36 AM Last Post: Knight18

Users browsing this thread: 1 Guest(s)

View a Printable Version

csv.reader(): Limit the number of columns read in Windows

User Panel Messages

Announcements