cnki-advanced-search

You can automate CNKI advanced literature search and export to Excel by using a staged onion-peeling keyword strategy that queries CSSCI papers, deduplicates by title, and outputs a categorized spreadsheet.

The onion-peeling keyword strategy for literature retrieval builds a focused AND keyword approach for CNKI searches, then automatically degrades to wider search strategies when initial results are too few.

Yes, you can use Playwright-driven browser automation to handle checkpoint captcha and login during CNKI advanced search, enabling paginated selection and automated export of citation-sorted results.

You can retrieve both direct and indirect theoretical papers from CNKI by running separate supplementary searches that capture indirect background and theoretical foundations alongside direct intersecting hits.

The best way to filter CSSCI journal papers and deduplicate results is to apply automated citation sorting and title-based deduplication, producing a consolidated and color-coded Excel output categorizing direct versus indirect literature.

Yes, you need Playwright and openpyxl installed, as the automated CNKI search relies on Playwright for browser automation and openpyxl for generating the structured Excel file output.