| Line 192... |
Line 192... |
| 192 |
workbook = xlrd.open_workbook(filename)
|
192 |
workbook = xlrd.open_workbook(filename)
|
| 193 |
sheet = workbook.sheet_by_index(0)
|
193 |
sheet = workbook.sheet_by_index(0)
|
| 194 |
num_rows = sheet.nrows
|
194 |
num_rows = sheet.nrows
|
| 195 |
|
195 |
|
| 196 |
writer = csv.writer(open("junglee.csv", "wb"), delimiter='\t', quoting=csv.QUOTE_MINIMAL)
|
196 |
writer = csv.writer(open("junglee.csv", "wb"), delimiter='\t', quoting=csv.QUOTE_MINIMAL)
|
| - |
|
197 |
writer.writerow("Amazon.com Product Ads Header","Purge-Replace=false","","","","","",\
|
| - |
|
198 |
"","","","","","","",\
|
| - |
|
199 |
"","","","","","",\
|
| - |
|
200 |
"","","","","","",\
|
| - |
|
201 |
"","","","","","",\
|
| - |
|
202 |
"","","","","","",\
|
| - |
|
203 |
"","","","","","","",\
|
| - |
|
204 |
"","","","","",\
|
| - |
|
205 |
"","","","","","","", "","",\
|
| - |
|
206 |
"","","","","","",\
|
| - |
|
207 |
"","","","","",
|
| - |
|
208 |
"","","",""])
|
| 197 |
writer.writerow(["SKU","Title","Link","Price","Delivery Time","Recommended Browse Node","Standard Product ID",\
|
209 |
writer.writerow(["SKU","Title","Link","Price","Delivery Time","Recommended Browse Node","Standard Product ID",\
|
| 198 |
"Product ID Type","Category","Description","Shipping Cost","Image","List Price","Availability",\
|
210 |
"Product ID Type","Category","Description","Shipping Cost","Image","List Price","Availability",\
|
| 199 |
"Brand","Manufacturer","Mfr part number","Model Number","Computer CPU speed","Hard disk size",\
|
211 |
"Brand","Manufacturer","Mfr part number","Model Number","Computer CPU speed","Hard disk size",\
|
| 200 |
"Included RAM size","Optical zoom","Digital zoom","Megapixels","Display size","Screen Resolution",\
|
212 |
"Included RAM size","Optical zoom","Digital zoom","Megapixels","Display size","Screen Resolution",\
|
| 201 |
"Display Technology","Flash drive Size","Memory Card Type","Camera type","Viewfinder type","Flash type",\
|
213 |
"Display Technology","Flash drive Size","Memory Card Type","Camera type","Viewfinder type","Flash type",\
|
| Line 306... |
Line 318... |
| 306 |
|
318 |
|
| 307 |
for item_detail in item_details:
|
319 |
for item_detail in item_details:
|
| 308 |
writer.writerow(item_detail)
|
320 |
writer.writerow(item_detail)
|
| 309 |
|
321 |
|
| 310 |
if __name__ == '__main__':
|
322 |
if __name__ == '__main__':
|
| 311 |
main()
|
- |
|
| 312 |
|
323 |
main()
|
| - |
|
324 |
|