I am working with a large xml files that is about 80000KB and it's full of data. It's bigger that the maximum allowed in excel. So When I try to import it as a table in excel I get an error.
I am looking for alternatives on how to import the data in excel. I am thinking it may be best to split the xml files in 2 or 3 smaller xml files. Then Import them separately in excel.
The issue is I am not well versed in excel VBA and would like some help In doing so.
This is what the xml files look like.
<satellite_system sat_name="STEAM-1" ntc_id="114520273">
<pfd_mask mask_id="325" low_freq_mhz="10700" high_freq_mhz="12750" refbw_khz="40" type="azimuth_elevation" a_name="latitude" b_name="azimuth" c_name="elevation">
<by_a a="-85">
<by_b b="-59">
<pfd c="-59">-1000</pfd>
<pfd c="-58">-1000</pfd>
<pfd c="-57">-1000</pfd>
<pfd c="-56">-1000</pfd>
For every a and every b values, there's a lot of c values.
Please help!
I am looking for alternatives on how to import the data in excel. I am thinking it may be best to split the xml files in 2 or 3 smaller xml files. Then Import them separately in excel.
The issue is I am not well versed in excel VBA and would like some help In doing so.
This is what the xml files look like.
<satellite_system sat_name="STEAM-1" ntc_id="114520273">
<pfd_mask mask_id="325" low_freq_mhz="10700" high_freq_mhz="12750" refbw_khz="40" type="azimuth_elevation" a_name="latitude" b_name="azimuth" c_name="elevation">
<by_a a="-85">
<by_b b="-59">
<pfd c="-59">-1000</pfd>
<pfd c="-58">-1000</pfd>
<pfd c="-57">-1000</pfd>
<pfd c="-56">-1000</pfd>
For every a and every b values, there's a lot of c values.
Please help!