Tab Delimited Text Copy Paste To Excel

0 votes
I'm using C# Stringbuilder to create a block of text that is properly tab-delimited (using new lines, "t," etc.) and displaying it within a tag in my web application. All of the text pastes into the first column of the spreadsheet when I copy and paste this into Excel.

The data pastes cleanly into individual cells when I copy the block's outerHTML (in Chrome) or copy/paste it into Notepad++ and THEN paste to Excel, which is the intended result of this effort. Could someone please explain how I may copy the text from my program and paste it into Excel so that it pastes into individual cells and maintains the tab-delimited format?
Oct 29 in Others by Kithuzzz
• 20,660 points
47 views

1 answer to this question.

0 votes
By switching the element my text was written to from a div to a textarea, I was able to paste it to Excel while maintaining the formatting. When copied and pasted from a textarea to an Excel spreadsheet with tab delimiters, the data retains its tabular format. I want to thank everyone for their assistance.
answered Oct 29 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
205 views
0 votes
1 answer

How to paste an Excel chart into PowerPoint placeholder using Python?

Very near indeed! Copy and Paste are ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
262 views
0 votes
1 answer

Convert text to number in Google Sheets & Excel

Try: =INDEX(IF(REGEXMATCH(A1:A4&""; "M"); REGEXEXTRACT(A1:A4; "\d+.\d+|\d+")*1000000; IF(REGEXMATCH(A1:A4&""; "k"); ...READ MORE

answered Oct 15 in Others by narikkadan
• 37,660 points
62 views
0 votes
1 answer

Append same text to every cell in a column in Excel

Solution All your data is in column A ...READ MORE

answered Oct 17 in Others by narikkadan
• 37,660 points
68 views
0 votes
1 answer

Generate a flat list of all excel cell formulas

Hello, you'll have to follow certain steps ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
79 views
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
143 views
0 votes
1 answer

Deleting duplicate rows in Excel using Epplus

You need to re-think this… the while ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
296 views
0 votes
1 answer

Export DataTable to Excel File

Add Interop References. First we need to ...READ MORE

answered Jun 9 in JQuery by gaurav
• 22,040 points
109 views
0 votes
1 answer

How to define excel SUMIFS criteria considering any text and numbers?

It essentially ignores column C's missing entry ...READ MORE

answered Oct 1 in Others by narikkadan
• 37,660 points
70 views
0 votes
1 answer

How to Paste JPEG as a gif in excel?

Solution  Step 1 Navigate to the folder that contains ...READ MORE

answered Oct 2 in Others by narikkadan
• 37,660 points
53 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP