Jump to content
sunshaker

copy and paste xls?

Recommended Posts

My computer skills are not great to say the least,

Just wondered if anyone can tell me is there a easy way to copy and paste from xl to a thread/post, without all my figures merging together and losing colour?

As shown below, is there a special format to use?

 

Cheers.

 

http://alphaomegadotme.files.wordpress.com/2013/02/grouped-elements-old-quarkstargalaxyuniv.xls FIG 3 SHOWN IN PURPLE THE ELECTRONS BEFORE I CHANGED THEM TO FOLLOW SEQUENCE 1 HYDROGEN 1 2 8 8 18 18 32 32 18 18 8 8 2 172 2 HELIUM 2 1 8 8 18 18 32 32 18 18 8 8 2 171 3 LITHIUM 2 1 8 8 8 18 18 32 32 18 18 8 2 170 4 BERYLLIUM 2 2 7 8 8 18 18 32 32 18 18 8 2 169 5 BORON 2 3 6 8 8 18 18 32 32 18 18 8 2 168 6 CARBON 2 4 5 8 8 18 18 32 32 18 18 8 2 167 7 NITROGEN 2 5 4 8 8 18 18 32 32 18 18 8 2 166 8 OXYGEN 2 6 3 8 8 18 18 32 32 18 18 8 2 165 9 FLUORINE 2 7 2 8 8 18 18 32 32 18 18 8 2 164 10 #NEON 2 8 1 8 8 18 18 32 32 18 18 8 2 163 11 SODIUM 2 8 1 8 8 18 18 32 32 18 18 8 2 162 12 MAGNESIUM 2 8 2 7 8 18 18 32 32 18 18 8 2 161 13 ALUMINIUM 2 8 3 6 8 18 18 32 32 18 18 8 2 160 14 SILICON 2 8 4 5 8 18 18 32 32 18 18 8 2 159 15 PHOSPHERUS 2 8 5 4 8 18 18 32 32 18 18 8 2 158 16 SULPHUR 2 8 6 3 8 18 18 32 32 18 18 8 2 157 17 CHLORINE 2 8 7 2 8 18 18 32 32 18 18 8 2 156 18 # ARGON 2 8 8 1 8 18 18 32 32 18 18 8 2 155 19 POTASSIUM 2 8 8 1 8 18 18 32 32 18 18 8 2 154 20 CALCIUM 2 8 8 2 7 18 18 32 32 18 18 8 2 153 21 SCANDIUM 2 8 9 2 6 18 18 32 32 18 18 8 2 152 22 TITANIUM 2 8 10 2 5 18 18 32 32 18 18 8 2 151 23 VANADIUM 2 8 11 2 4 18 18 32 32 18 18 8 2 150 24 CHROMIUM 2 8 13 1 3 18 18 32 32 18 18 8 2 149 25 MANGANESE 2 8 13 2 2 18 18 32 32 18 18 8 2 148 26 IRON 2 8 14 2 1 18 18 32 32 18 18 8 2 147 27 COBALT 2 8 15 2 1 17 18 18 32 32 18 8 2 146 28 NICKEL 2 8 16 2 1 16 18 18 32 32 18 8 2 145 29 COPPER 2 8 18 1 8 8 18 18 32 32 18 8 2 144 30 ZINC 2 8 18 2 7 8 18 18 32 32 18 8 2 143 31 GALLIUM 2 8 18 3 6 8 18 18 32 32 18 8 2 142 32 GERMANIUM 2 8 18 4 5 8 18 18 32 32 18 8 2 141 33 ARSENIC 2 8 18 5 4 8 18 18 32 32 18 8 2 140 34 SELENIUM 2 8 18 6 3 8 18 18 32 32 18 8 2 139 35 BROMINE 2 8 18 7 2 8 18 18 32 32 18 8 2 138 36 #KRYPTON 2 8 18 8 1 8 18 18 32 32 18 8 2 137 37 RUBIDIUM 2 8 18 8 1 8 18 18 32 32 18 8 2 136 38 STRONTIUM 2 8 18 8 2 7 18 18 32 32 18 8 2 135 39 YTTRIUM 2 8 18 9 2 6 18 18 32 32 18 8 2 134 40 ZIRCONIUM 2 8 18 10 2 5 18 18 32 32 18 8 2 133 41 NIOBIUM 2 8 18 12 1 4 18 18 32 32 18 8 2 132 42 MOLYBDENIUM 2 8 18 13 1 3 18 18 32 32 18 8 2 131 43 TECHNETIUM 2 8 18 13 2 2 18 18 32 32 18 8 2 130 44 RUTHENIUM 2 8 18 15 1 1 18 18 32 32 18 8 2 129 45 RHODIUM 2 8 18 16 1 1 17 18 32 32 18 8 2 128 46 PALLADIUM 2 8 18 18 1 16 18 32 32 18 8 2 127 47 SILVER 2 8 18 18 1 8 8 18 32 32 18 8 2 126 48 CADIUM 2 8 18 18 2 7 8 18 32 32 18 8 2 125 49 INDIUM 2 8 18 18 3 6 8 18 32 32 18 8 2 124 50 TIN 2 8 18 18 4 5 8 18 32 32 18 8 2 123 51 ANTIMONY 2 8 18 18 5 4 8 18 32 32 18 8 2 122 52 TELLURIUM 2 8 18 18 6 3 8 18 32 32 18 8 2 121 53 IODINE 2 8 18 18 7 2 8 18 32 32 18 8 2 120 54 #XENON 2 8 18 18 8 1 8 18 32 32 18 8 2 119 55 CAESIUM 2 8 18 18 8 1 8 18 32 32 18 8 2 #UNUNOCTIUM 56 BARIUM 2 8 18 18 8 2 7 18 32 32 18 8 2 UNUNSEPTIUM 57 LANTHANIUM 2 8 18 18 9 2 6 18 32 32 18 8 2 LIVERMOTIUM 58 CERIUM 2 8 18 19 9 2 5 18 32 32 18 8 2 UNUNPENTIUM 59 PRASEDYM 2 8 18 21 8 2 4 18 32 32 18 8 2 FLEROVIUM 60 NEODYMIUM 2 8 18 22 8 2 3 18 32 32 18 8 2 UNUNTRIUM 61 PROMETHIUM 2 8 18 23 8 2 2 18 32 32 18 8 2 COPERNIC 62 SAMARIUM 2 8 18 24 8 2 2 17 32 32 18 8 2 ROENTGENIUM 63 EUROPIUM 2 8 18 25 8 2 2 16 32 32 18 8 2 DARMSTADTIUM 64 GADOLINIUM 2 8 18 25 9 2 2 15 32 32 18 8 2 MEITNERIUM 65 TERBIUM 2 8 18 27 8 2 2 14 32 32 18 8 2 HASSIUM 66 DYSPROSIUM 2 8 18 28 8 2 2 13 32 32 18 8 2 BOHRIUM 67 HOLMIUM 2 8 18 29 8 2 2 12 32 32 18 8 2 SEABORGIUM 68 ERBIUM 2 8 18 30 8 2 2 11 32 32 18 8 2 DUBINIUM 69 THULIUM 2 8 18 31 8 2 2 10 32 32 18 8 2 RUTHURFORDIUM 70 YTTERBIUM 2 8 18 32 8 2 2 9 32 32 18 8 2 LANRENCIUM 71 LUTETIUM 2 8 18 32 9 2 2 8 32 32 18 8 2 NOBLEIUM 72 HAFNIUM 2 8 18 32 10 2 2 8 31 32 18 8 2 MENDELEVIUM 73 TANTALUM 2 8 18 32 11 2 2 8 30 32 18 8 2 FERMIUM 74 TUNGSTEN 2 8 18 32 12 2 2 8 29 32 18 8 2 EINSTEINIUM 75 RHENIUM 2 8 18 32 13 2 2 8 28 32 18 8 2 CALIFORNIUM 76 OSMIUM 2 8 18 32 14 2 2 8 27 32 18 8 2 BERKELIUM 77 IRIDIUM 2 8 18 32 15 2 2 8 26 32 18 8 2 CURIUM 78 PLATINUM 2 8 18 32 17 1 2 8 25 32 18 8 2 AMERICIUM 79 GOLD 2 8 18 32 18 1 2 8 24 32 18 8 2 PLUTONIUM 80 MERCURY 2 8 18 32 18 2 2 9 22 32 18 8 2 NEPTUNIUM 81 THALLIUM 2 8 18 32 18 3 2 9 21 32 18 8 2 URANIUM 82 LEAD 2 8 18 32 18 4 2 9 20 32 18 8 2 PROTACTINIUM 83 BISMUTH 2 8 18 32 18 5 2 10 18 32 18 8 2 THORIUM 84 POLONIUM 2 8 18 32 18 6 2 9 18 32 18 8 2 ACTINIUM 85 ASTATINE 2 8 18 32 18 7 2 8 18 32 18 8 2 RADIUM 86 #RADON 2 8 18 32 18 8 1 8 18 32 18 8 2 FRANCIUM2 8 87 FRANCIUM 2 8 18 32 18 8 1 8 18 32 18 8 2 #RADON 88 RADIUM 2 8 18 32 18 8 2 7 18 32 18 8 2 ASTATINE 89 ACTINIUM 2 8 18 32 18 9 2 6 18 32 18 8 2 POLONIUM 90 THORIUM 2 8 18 32 18 10 2 5 18 32 18 8 2 BISMUTH 91 PROTACTIUM 2 8 18 32 20 9 2 4 18 32 18 8 2 LEAD 92 URANIUM 2 8 18 32 21 9 2 3 18 32 18 8 2 THALLIUM 93 NEPTUNIUM 2 8 18 32 22 9 2 2 18 32 18 8 2 MERCURY 94 PLUTONIUM 2 8 18 32 24 8 2 1 18 32 18 8 2 GOLD 95 AMERICIUM 2 8 18 32 25 8 2 1 17 32 18 8 2 PLATINUM 96 CURIUM 2 8 18 32 25 9 2 2 15 32 18 8 2 IRIDIUM 97 BERKELIUM 2 8 18 32 27 8 2 2 14 32 18 8 2 OSMIUM 98 CALIFORNIUM 2 8 18 32 28 8 2 2 13 32 18 8 2 RHENIUM 99 EINSTEINIUM 2 8 18 32 29 8 2 2 12 32 18 8 2 TUNGSTEN 100 FERMIUM 2 8 18 32 30 8 2 2 11 32 18 8 2 TANTALUM 101 MENDELEVIUM 2 8 18 32 31 8 2 2 10 32 18 8 2 HAFNIUM 102 NOBLEIUM 2 8 18 32 32 8 2 2 9 32 18 8 2 LUTEIUM 103 LANRENCIUM 2 8 18 32 32 8 3 2 8 32 18 8 2 YTTERBIUM 104 RUTHURFORDIUM 2 8 18 32 32 10 2 2 8 31 18 8 2 THULIUM 105 DUBINIUM 2 8 18 32 32 11 2 2 8 30 18 8 2 ERBIUM 106 SEABORGIUM 2 8 18 32 32 12 2 2 8 29 18 8 2 HOLMIUM 107 BOHRIUM 2 8 18 32 32 13 2 2 8 28 18 8 2 DYSPROSIUM 108 HASSIUM 2 8 18 32 32 14 2 2 8 27 18 8 2 TERBIUM 108 MEITNERIUM 2 8 18 32 32 15 2 2 8 26 18 8 2 GADOLINIUM 110 DARMSTADTIUM 2 8 18 32 32 17 1 2 8 25 18 8 2 EUROPIUM 111 ROENTGENIUM 2 8 18 32 32 18 1 2 8 24 18 8 2 SAMARIUM 112 COPERNICIUM 2 8 18 32 32 18 2 2 8 23 18 8 2 PROMETHIUM 113 UNUNTRIUM 2 8 18 32 32 18 3 2 8 22 18 8 2 NEODYMIUM 114 FLEROVIUM 2 8 18 32 32 18 4 2 8 21 18 8 2 PRASEDYM 115 UNUNPENTIUM 2 8 18 32 32 18 5 2 9 19 18 8 2 CERIUM 116 LIVERMOTIUM 2 8 18 32 32 18 6 2 9 18 18 8 2 LANTHANIUM 117 UNUNSEPTIUM 2 8 18 32 32 18 7 2 8 18 18 8 2 BARIUM 118 #UNUNOCTIUM 2 8 18 32 32 18 8 1 8 18 18 8 2 CAESIUM 119 2 8 18 32 32 18 8 1 8 18 18 8 2 #XENON 120 2 8 18 32 32 18 8 2 7 18 18 8 2 IODINE 121 2 8 18 32 32 18 8 3 6 18 18 8 2 TELLURIUM 122 2 8 18 32 32 18 8 4 5 18 18 8 2 ANTIMONY 123 2 8 18 32 32 18 8 5 4 18 18 8 2 TIN 124 2 8 18 32 32 18 8 6 3 18 18 8 2 INDIUM 125 2 8 18 32 32 18 8 7 2 18 18 8 2 CADIUM 126 2 8 18 32 32 18 8 8 1 18 18 8 2 SILVER 127 2 8 18 32 32 18 16 1 18 18 8 2 PALLADIUM 128 2 8 18 32 32 18 17 1 1 16 18 8 2 RHODIUM 129 2 8 18 32 32 18 18 1 1 15 18 8 2 RUTHENIUM 130 2 8 18 32 32 18 18 2 2 13 18 8 2 TECHNETIUM 131 2 8 18 32 32 18 18 3 1 13 18 8 2 MOLYBDENIUM 132 2 8 18 32 32 18 18 4 1 12 18 8 2 NIOBIUM 133 2 8 18 32 32 18 18 5 2 10 18 8 2 ZIRCONIUM 134 2 8 18 32 32 18 18 6 2 9 18 8 2 YTTRIUM 135 2 8 18 32 32 18 18 7 2 8 18 8 2 STRONTIUM #136 2 8 18 32 32 18 18 8 1 8 18 8 2 RUBIDIUM 2 8 137 2 8 18 32 32 18 18 8 1 8 18 8 2 #KRYPTON 138 2 8 18 32 32 18 18 8 2 7 18 8 2 BROMINE 139 2 8 18 32 32 18 18 8 3 6 18 8 2 SELENIUM 140 2 8 18 32 32 18 18 8 4 5 18 8 2 ARSENIC 141 2 8 18 32 32 18 18 8 5 4 18 8 2 GERMANIUM 142 2 8 18 32 32 18 18 8 6 3 18 8 2 GALIUM 143 2 8 18 32 32 18 18 8 7 2 18 8 2 ZINC 144 2 8 18 32 32 18 18 8 8 1 18 8 2 COPPER 145 2 8 18 32 32 18 18 16 1 1 16 8 2 NICKEL 146 2 8 18 32 32 18 18 17 1 2 15 8 2 COBALT 147 2 8 18 18 32 32 18 18 1 2 14 8 2 IRON 148 2 8 18 18 32 32 18 18 2 2 13 8 2 MANGANESE 149 2 8 18 18 32 32 18 18 3 1 13 8 2 CHROMIUM 150 2 8 18 18 32 32 18 18 4 2 11 8 2 VANADIUM 151 2 8 18 18 32 32 18 18 5 2 10 8 2 TITANIUM 152 2 8 18 18 32 32 18 18 6 2 9 8 2 SCANDIUM 153 2 8 18 18 32 32 18 18 7 2 8 8 2 CALCIUM #154 2 8 18 18 32 32 18 18 8 1 8 8 2 POTASSIUM 155 2 8 18 18 32 32 18 18 8 1 8 8 2 #ARGON 156 2 8 18 18 32 32 18 18 8 2 7 8 2 CHLORINE 157 2 8 18 18 32 32 18 18 8 3 6 8 2 SULPHUR 158 2 8 18 18 32 32 18 18 8 4 5 8 2 PHOSPHERUS 159 2 8 18 18 32 32 18 18 8 5 4 8 2 SILICON 160 2 8 18 18 32 32 18 18 8 6 3 8 2 ALUMINIUM 161 2 8 18 18 32 32 18 18 8 7 2 8 2 MAGNESIUM #162 2 8 18 18 32 32 18 18 8 8 1 8 2 SODIUM 2 163 2 8 18 18 32 32 18 18 8 8 1 8 2 NEON 164 2 8 18 18 32 32 18 18 8 8 2 7 2 FLUORINE 165 2 8 18 18 32 32 18 18 8 8 3 6 2 OXYGEN 166 2 8 18 18 32 32 18 18 8 8 4 5 2 NITOOGEN 167 2 8 18 18 32 32 18 18 8 8 5 4 2 CARBON 168 2 8 18 18 32 32 18 18 8 8 6 3 2 BORON 169 2 8 18 18 32 32 18 18 8 8 7 2 2 BERYLLIUM #170 2 8 18 18 32 32 18 18 8 8 8 1 2 LITHIUM 171 2 8 18 18 32 32 18 18 8 8 8 1 2 HELIUM 172 2 8 8 18 18 32 32 18 18 8 8 2 1 HYDRO

 

Share this post


Link to post
Share on other sites

I'm no computer wiz either, but you could copy-paste it as a figure, not as a table (I don't think that you can put a table on our forum, which is a pity really...).

[edit] Or, to be more specific: copy and paste it as a picture somewhere, then upload the picture.

Share this post


Link to post
Share on other sites

[edit] Or, to be more specific: copy and paste it as a picture somewhere, then upload the picture.

 

I loaded his xls to OpenOffice..

It has 1300 rows.. >50 columns each

Taking screen-shot would be challenge itself (maybe rather hundred screen-shots).

Share this post


Link to post
Share on other sites

I just tried to copy and paste as a picture, does not accept in this community, but it may work else where cheers.

 

I am not trying to copy paste everything, just parts( one table of elements 172 rows 15 columns), I wanted to be able to show tables without having people have to download xl doc.

Not just on here but for my own personal use.

 

cheers.

Share this post


Link to post
Share on other sites

You'd have to convert it to an html table(Save as Webpage) and then from there to BBCode. Then you need a forum which accepts that style of BBCode.

 

The BBCode for tables is actually here under the Special BBCode button(3rd top left), but I couldn't get it to work properly. Not sure if there is some trick or there's something off in the implementation.

 

The picture route and then uploading it to somewhere like Imgur is probably the way to go.

 

You should also be able to upload it to somewhere like Google Spreadsheets. Obviously not on the same page, but would save them a download.

Edited by Endy0816

Share this post


Link to post
Share on other sites

I'm on a phone at the moment, so can't try, but the [ code] tag might work.

Share this post


Link to post
Share on other sites

I was just about to say about to say i had no luck on the picture route, Then i tried code tag, but still could not get anything legible,

 

Then Stringjunky's post appeared, that is just what i wanted :) ,

 

Can you explain how you done it please.

Edited by sunshaker

Share this post


Link to post
Share on other sites

Which Excel do you have? This was done in the 2003 version. Highlight your target cells > Hold Shift and click Edit (top row) > Select Copy Picture > Select Bitmap > Click OK. It is now on the clipboard. Open a picture editor like Paint or Fastone Image Viewer or some such and click Paste in the Edit menu. Click Save As in the File menu in your preferred image format. PNG is good for graphic images like yours.

Edited by StringJunky

Share this post


Link to post
Share on other sites

my office is a free one : office suite x 3.3. how did you get the chart and colour up, did you use this forums code tag?

Share this post


Link to post
Share on other sites

No, I clicked More Reply Options > Go to Attach Files (bottom of text input box) > Click Browse (Select file) > Click Attach This File > Click Add To Post

 

Is it Libre Office?

Edited by StringJunky

Share this post


Link to post
Share on other sites

I got it to work in Apache Open Office which is free …method is slightly different. Install both programs first if you want paint.net as well:

 

http://www.openoffice.org/download/

 

http://www.getpaint.net/

 

Open the spreadsheet in Open Office Spreadsheet (Calc). You first need to convert the .xls file to ODF Spreadsheet (.ods) by clicking File > Save As > Choose ODF Spreadsheet > Save. Then highlight your desired cells for your image(s). Right-click on the highlighted area and select Copy. Open an image editor and select Edit > Paste. Save the image in your desired image format. Paint.net is my usual editor and free.

Edited by StringJunky

Share this post


Link to post
Share on other sites

Thank you Stringjunky, I downloaded excel 2003 last night b4 i went to bed, been at hospital all day today, as my "temple" is crumbling in places at the moment, I am downloading your links at the moment, it may take a while for me to get it right, But with your information i am sure i will work it out.

Ingratitude sunshaker.

 

edit:first attempt great, cheers again,

 

string1.png?w=640&h=655

Edited by sunshaker

Share this post


Link to post
Share on other sites

Thank you Stringjunky, I downloaded excel 2003 last night b4 i went to bed, been at hospital all day today, as my "temple" is crumbling in places at the moment, I am downloading your links at the moment, it may take a while for me to get it right, But with your information i am sure i will work it out.

Ingratitude sunshaker.

The Open Office looks better than Office 2003 as it's more modern and for what you want to do is as easy as I wrote it. Just post if you get stuck.

Share this post


Link to post
Share on other sites

The Open Office looks better than Office 2003 as it's more modern and for what you want to do is as easy as I wrote it. Just post if you get stuck.

WORKS GREAT :) , Cheers, This gives me more dimensions to explore, Thank you for the time you put into this.

 

string1.png?w=640&h=655

Edited by sunshaker

Share this post


Link to post
Share on other sites

Glad you got it sorted. The resolution on yours is not good when expanded though. Try choosing Bitmap rather than Picture when you Shift + Edit to bring up the Copy Picture command in the Edit menu after highlighting the picture in Excel. Or did you save as JPEG instead of PNG?

 

post-14463-0-97961100-1396551548.png

Edited by StringJunky

Share this post


Link to post
Share on other sites

I saved as png, more luck than skill.

The resolution is not to bad at this size, Which is plenty good enough for me, It gives me something to experiment with :)

period-1.png?w=640&h=1385.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.