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, 2022 in Others by Kithuzzz
• 38,010 points
295 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, 2022 by narikkadan
• 63,180 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, 2022 in Others by Edureka
• 13,670 points
623 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, 2022 in Others by narikkadan
• 63,180 points
299 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, 2022 in Others by narikkadan
• 63,180 points
2,750 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, 2022 in Others by narikkadan
• 63,180 points
846 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, 2022 in Others by gaurav
• 23,220 points
293 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, 2022 in Database by gaurav
• 23,220 points
457 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, 2022 in Database by gaurav
• 23,220 points
865 views
0 votes
1 answer

Export DataTable to Excel File

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

answered Jun 9, 2022 in JQuery by gaurav
• 23,220 points
479 views
0 votes
1 answer

Excel VBA userform paste text in expanded format (not just to one cell)

It should work if you simply supply ...READ MORE

answered Jan 21 in Others by narikkadan
• 63,180 points
292 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, 2022 in Others by narikkadan
• 63,180 points
427 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