Skip to main content
added 186 characters in body
Source Link
Sjoerd C. de Vries
  • 66.1k
  • 15
  • 189
  • 327

Using Adobe Acrobat I exported the file as XML and .DOC.

The first file can be read directly using

Import["SoLux Spectral Data.xls.xml", "XML"]

but you have to cut your way through the resulting XML expression tree.

The second method involves using MS Word. After opening the .doc file, I selected the table, copied it and pasted it in the following expression:

ImportString["","TSV"]

The insertion point should be precisely in the empty string (""). After pasting, you will get this dialog box:

Mathematica graphics

Press "Yes", evaluate the result and you get:

{{"Wavelength ", "4700K ", "4100K ", "3500K "}, {280, 0.049379, 0.054292, 0.0503}, {290, 0.075516, 0.037844, 0.034862}, {300, 0.11254, 0.030544, 0.028027}, {310, 0.16051, 0.033413, 0.029238}, {320, 0.23068, 0.067789, 0.055261}, {330, 0.32281, 0.20151, 0.13953}, {340, 0.40282, 0.43615, 0.25661}, {350, 0.45898, 0.57172, 0.52681}, {360, 1.2011, 0.82864, 1.3278}, {370, 1.8647, 1.5222, 1.6987}, {380, 2.5338, 2.3844, 3.61}, {390, 3.5809, 4.5686, 3.9927}, {400, 4.4137, 8.4548, 8.168}, {410, 5.2228, 14.205, 13.863}, {420, 6.0387, 17.949, 17.46}, {430, 6.9944, 21.068, 20.103}, ... }

If Word seems to copy only part of the table, try pasting it first in Excel before going to Mathematica, doing a bit of polishing there. Copying to the welcoming quotes in Mathematica will then do the trick.

Using Adobe Acrobat I exported the file as XML and .DOC.

The first file can be read directly using

Import["SoLux Spectral Data.xls.xml", "XML"]

but you have to cut your way through the resulting XML expression tree.

The second method involves using MS Word. After opening the .doc file, I selected the table, copied it and pasted it in the following expression:

ImportString["","TSV"]

The insertion point should be precisely in the empty string (""). After pasting, you will get this dialog box:

Mathematica graphics

Press "Yes", evaluate the result and you get:

{{"Wavelength ", "4700K ", "4100K ", "3500K "}, {280, 0.049379, 0.054292, 0.0503}, {290, 0.075516, 0.037844, 0.034862}, {300, 0.11254, 0.030544, 0.028027}, {310, 0.16051, 0.033413, 0.029238}, {320, 0.23068, 0.067789, 0.055261}, {330, 0.32281, 0.20151, 0.13953}, {340, 0.40282, 0.43615, 0.25661}, {350, 0.45898, 0.57172, 0.52681}, {360, 1.2011, 0.82864, 1.3278}, {370, 1.8647, 1.5222, 1.6987}, {380, 2.5338, 2.3844, 3.61}, {390, 3.5809, 4.5686, 3.9927}, {400, 4.4137, 8.4548, 8.168}, {410, 5.2228, 14.205, 13.863}, {420, 6.0387, 17.949, 17.46}, {430, 6.9944, 21.068, 20.103}, ... }

Using Adobe Acrobat I exported the file as XML and .DOC.

The first file can be read directly using

Import["SoLux Spectral Data.xls.xml", "XML"]

but you have to cut your way through the resulting XML expression tree.

The second method involves using MS Word. After opening the .doc file, I selected the table, copied it and pasted it in the following expression:

ImportString["","TSV"]

The insertion point should be precisely in the empty string (""). After pasting, you will get this dialog box:

Mathematica graphics

Press "Yes", evaluate the result and you get:

{{"Wavelength ", "4700K ", "4100K ", "3500K "}, {280, 0.049379, 0.054292, 0.0503}, {290, 0.075516, 0.037844, 0.034862}, {300, 0.11254, 0.030544, 0.028027}, {310, 0.16051, 0.033413, 0.029238}, {320, 0.23068, 0.067789, 0.055261}, {330, 0.32281, 0.20151, 0.13953}, {340, 0.40282, 0.43615, 0.25661}, {350, 0.45898, 0.57172, 0.52681}, {360, 1.2011, 0.82864, 1.3278}, {370, 1.8647, 1.5222, 1.6987}, {380, 2.5338, 2.3844, 3.61}, {390, 3.5809, 4.5686, 3.9927}, {400, 4.4137, 8.4548, 8.168}, {410, 5.2228, 14.205, 13.863}, {420, 6.0387, 17.949, 17.46}, {430, 6.9944, 21.068, 20.103}, ... }

If Word seems to copy only part of the table, try pasting it first in Excel before going to Mathematica, doing a bit of polishing there. Copying to the welcoming quotes in Mathematica will then do the trick.

deleted 1199 characters in body
Source Link
Sjoerd C. de Vries
  • 66.1k
  • 15
  • 189
  • 327

The first file can be read directly using Import,

Import["SoLux Spectral Data.xls.xml", "XML"]

but you have to cut your way through the resulting XML expression tree.

The Word document can be edited insecond method involves using MS Word. After opening the .doc file, I selected the table, copied it and pasted it in the following expression:

{{"Wavelength ", "4700K ", "4100K ", "3500K "}, {280, 0.049379, 0.054292, 0.0503}, {290, 0.075516, 0.037844, 0.034862}, {300, 0.11254, 0.030544, 0.028027}, {310, 0.16051, 0.033413, 0.029238}, {320, 0.23068, 0.067789, 0.055261}, {330, 0.32281, 0.20151, 0.13953}, {340, 0.40282, 0.43615, 0.25661}, {350, 0.45898, 0.57172, 0.52681}, {360, 1.2011, 0.82864, 1.3278}, {370, 1.8647, 1.5222, 1.6987}, {380, 2.5338, 2.3844, 3.61}, {390, 3.5809, 4.5686, 3.9927}, {400, 4.4137, 8.4548, 8.168}, {410, 5.2228, 14.205, 13.863}, {420, 6.0387, 17.949, 17.46}, {430, 6.9944, 21.068, 20.103}, {440, 8.0266, 24.197, 22.749}, {450, 8.9276, 26.566, 25.29}, {460, 9.784, 29.742, 29.504}, {470, 10.639, 32.026, 34.031}, {480, 11.36, 34.481, 38.672}, {490, 12.134, 35.13, 42.426}, {500, 12.588, 35.697, 45.865}, {510, 12.879, 36.763, 48.879}, {520, 13.256, 39.004, 50.531}, {530, 13.522, 41.494, 51.872}, {540, 13.307, 44.69, 51.928}, {550, 13.399, 46.9, 54.015}, {560, 13.342, 47.855, 57.846}, {570, 13.422, 47.635, 62.65}, {580, 13.271, 46.411, 66.065}, {590, 13.233, 46.058, 67.369}, {600, 13.011, 47.344, 70.26}, {610, 12.847, 50.005, 72.487}, {620, 12.763, 52.045, 72.578}, {630, 12.576, 55.075, 72.447}, {640, 12.549, 56.823, 72.471}, {650, 12.633, 56.884, 73.047}, {660, 12.601, 55.523, 75.449}, {670, 12.631, 53.732, 77.543}, {680, 12.624, 51.425, 80.04}, {690, 12.771, 49.183, 81.394}, {700, 12.781, 48.273, 82.84}, {710, 12.795, 48.169, 83.614}, {720, 12.685, 49.915, 83.1}, {730, 12.595, 53.099, 81.615}, {740, 12.542, 56.852, 78.606}, {750, 12.318, 60.09, 73.221}, {760, 11.834, 63.253, 66.006}, {770, 11.619, 63.834, 58.844}, {780, 11.502, 63.468, 53.292}, {790, 11.151, 61.373, 48.839}, {800, 10.953, 58.181, 45.013}}

The first file can be read directly using Import, but you have to cut your way through the resulting XML expression tree.

The Word document can be edited in Word. I selected the table, copied it and pasted it in the following expression:

{{"Wavelength ", "4700K ", "4100K ", "3500K "}, {280, 0.049379, 0.054292, 0.0503}, {290, 0.075516, 0.037844, 0.034862}, {300, 0.11254, 0.030544, 0.028027}, {310, 0.16051, 0.033413, 0.029238}, {320, 0.23068, 0.067789, 0.055261}, {330, 0.32281, 0.20151, 0.13953}, {340, 0.40282, 0.43615, 0.25661}, {350, 0.45898, 0.57172, 0.52681}, {360, 1.2011, 0.82864, 1.3278}, {370, 1.8647, 1.5222, 1.6987}, {380, 2.5338, 2.3844, 3.61}, {390, 3.5809, 4.5686, 3.9927}, {400, 4.4137, 8.4548, 8.168}, {410, 5.2228, 14.205, 13.863}, {420, 6.0387, 17.949, 17.46}, {430, 6.9944, 21.068, 20.103}, {440, 8.0266, 24.197, 22.749}, {450, 8.9276, 26.566, 25.29}, {460, 9.784, 29.742, 29.504}, {470, 10.639, 32.026, 34.031}, {480, 11.36, 34.481, 38.672}, {490, 12.134, 35.13, 42.426}, {500, 12.588, 35.697, 45.865}, {510, 12.879, 36.763, 48.879}, {520, 13.256, 39.004, 50.531}, {530, 13.522, 41.494, 51.872}, {540, 13.307, 44.69, 51.928}, {550, 13.399, 46.9, 54.015}, {560, 13.342, 47.855, 57.846}, {570, 13.422, 47.635, 62.65}, {580, 13.271, 46.411, 66.065}, {590, 13.233, 46.058, 67.369}, {600, 13.011, 47.344, 70.26}, {610, 12.847, 50.005, 72.487}, {620, 12.763, 52.045, 72.578}, {630, 12.576, 55.075, 72.447}, {640, 12.549, 56.823, 72.471}, {650, 12.633, 56.884, 73.047}, {660, 12.601, 55.523, 75.449}, {670, 12.631, 53.732, 77.543}, {680, 12.624, 51.425, 80.04}, {690, 12.771, 49.183, 81.394}, {700, 12.781, 48.273, 82.84}, {710, 12.795, 48.169, 83.614}, {720, 12.685, 49.915, 83.1}, {730, 12.595, 53.099, 81.615}, {740, 12.542, 56.852, 78.606}, {750, 12.318, 60.09, 73.221}, {760, 11.834, 63.253, 66.006}, {770, 11.619, 63.834, 58.844}, {780, 11.502, 63.468, 53.292}, {790, 11.151, 61.373, 48.839}, {800, 10.953, 58.181, 45.013}}

The first file can be read directly using

Import["SoLux Spectral Data.xls.xml", "XML"]

but you have to cut your way through the resulting XML expression tree.

The second method involves using MS Word. After opening the .doc file, I selected the table, copied it and pasted it in the following expression:

{{"Wavelength ", "4700K ", "4100K ", "3500K "}, {280, 0.049379, 0.054292, 0.0503}, {290, 0.075516, 0.037844, 0.034862}, {300, 0.11254, 0.030544, 0.028027}, {310, 0.16051, 0.033413, 0.029238}, {320, 0.23068, 0.067789, 0.055261}, {330, 0.32281, 0.20151, 0.13953}, {340, 0.40282, 0.43615, 0.25661}, {350, 0.45898, 0.57172, 0.52681}, {360, 1.2011, 0.82864, 1.3278}, {370, 1.8647, 1.5222, 1.6987}, {380, 2.5338, 2.3844, 3.61}, {390, 3.5809, 4.5686, 3.9927}, {400, 4.4137, 8.4548, 8.168}, {410, 5.2228, 14.205, 13.863}, {420, 6.0387, 17.949, 17.46}, {430, 6.9944, 21.068, 20.103}, ... }

Source Link
Sjoerd C. de Vries
  • 66.1k
  • 15
  • 189
  • 327

Using Adobe Acrobat I exported the file as XML and .DOC.

The first file can be read directly using Import, but you have to cut your way through the resulting XML expression tree.

The Word document can be edited in Word. I selected the table, copied it and pasted it in the following expression:

ImportString["","TSV"]

The insertion point should be precisely in the empty string (""). After pasting, you will get this dialog box:

Mathematica graphics

Press "Yes", evaluate the result and you get:

{{"Wavelength ", "4700K ", "4100K ", "3500K "}, {280, 0.049379, 0.054292, 0.0503}, {290, 0.075516, 0.037844, 0.034862}, {300, 0.11254, 0.030544, 0.028027}, {310, 0.16051, 0.033413, 0.029238}, {320, 0.23068, 0.067789, 0.055261}, {330, 0.32281, 0.20151, 0.13953}, {340, 0.40282, 0.43615, 0.25661}, {350, 0.45898, 0.57172, 0.52681}, {360, 1.2011, 0.82864, 1.3278}, {370, 1.8647, 1.5222, 1.6987}, {380, 2.5338, 2.3844, 3.61}, {390, 3.5809, 4.5686, 3.9927}, {400, 4.4137, 8.4548, 8.168}, {410, 5.2228, 14.205, 13.863}, {420, 6.0387, 17.949, 17.46}, {430, 6.9944, 21.068, 20.103}, {440, 8.0266, 24.197, 22.749}, {450, 8.9276, 26.566, 25.29}, {460, 9.784, 29.742, 29.504}, {470, 10.639, 32.026, 34.031}, {480, 11.36, 34.481, 38.672}, {490, 12.134, 35.13, 42.426}, {500, 12.588, 35.697, 45.865}, {510, 12.879, 36.763, 48.879}, {520, 13.256, 39.004, 50.531}, {530, 13.522, 41.494, 51.872}, {540, 13.307, 44.69, 51.928}, {550, 13.399, 46.9, 54.015}, {560, 13.342, 47.855, 57.846}, {570, 13.422, 47.635, 62.65}, {580, 13.271, 46.411, 66.065}, {590, 13.233, 46.058, 67.369}, {600, 13.011, 47.344, 70.26}, {610, 12.847, 50.005, 72.487}, {620, 12.763, 52.045, 72.578}, {630, 12.576, 55.075, 72.447}, {640, 12.549, 56.823, 72.471}, {650, 12.633, 56.884, 73.047}, {660, 12.601, 55.523, 75.449}, {670, 12.631, 53.732, 77.543}, {680, 12.624, 51.425, 80.04}, {690, 12.771, 49.183, 81.394}, {700, 12.781, 48.273, 82.84}, {710, 12.795, 48.169, 83.614}, {720, 12.685, 49.915, 83.1}, {730, 12.595, 53.099, 81.615}, {740, 12.542, 56.852, 78.606}, {750, 12.318, 60.09, 73.221}, {760, 11.834, 63.253, 66.006}, {770, 11.619, 63.834, 58.844}, {780, 11.502, 63.468, 53.292}, {790, 11.151, 61.373, 48.839}, {800, 10.953, 58.181, 45.013}}